Sunday, February 19, 2012

Enterprise Manager & User permitions

I installed Enterprise Manager on user PC and now want him to be able to
delete and restore databases. Where do I need go to do this? I'm new in SQL
server.
Thank you,
AlexMake this login a member of the dbcreator fixed server role. For example:
sp_addsrvrolemember 'loginname','dbcreator'
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Alex" <alazor@.poli-film.net> wrote in message
news:uOg8vQo5DHA.2404@.TK2MSFTNGP11.phx.gbl...
quote:

> I installed Enterprise Manager on user PC and now want him to be able to
> delete and restore databases. Where do I need go to do this? I'm new in

SQL
quote:

> server.
> Thank you,
> Alex
>
|||I did add but it doesn't let him delete the database. It gives an error
message 3704 "User doesn't have permissions to delete database... SQL
Server-DMO ODBC SQL State 4300..."
I don't know if it has something to do with this but my SQL Server 2000 is
setup for "SQL Server and Windows Authentication" Any idea?
Thanks!
"Carlos Eduardo Rojas" <carloser@.mindspring.com> wrote in message
news:OPW6Vio5DHA.1632@.TK2MSFTNGP12.phx.gbl...
quote:

> Make this login a member of the dbcreator fixed server role. For example:
> sp_addsrvrolemember 'loginname','dbcreator'
> --
> Carlos E. Rojas
> SQL Server MVP
> Co-Author SQL Server 2000 programming by Example
>
> "Alex" <alazor@.poli-film.net> wrote in message
> news:uOg8vQo5DHA.2404@.TK2MSFTNGP11.phx.gbl...
> SQL
>
|||Then something weird is going on. Try this script to see if it works:
sp_addlogin 'testcreatedb','testcreatedb'
go
sp_addsrvrolemember 'testcreatedb','dbcreator'
go
-- now logon using the new login and run the following
create database test
go
drop database test
go
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Alex" <alazor@.poli-film.net> wrote in message
news:u%23SYrHp5DHA.2628@.TK2MSFTNGP10.phx.gbl...
quote:

> I did add but it doesn't let him delete the database. It gives an error
> message 3704 "User doesn't have permissions to delete database... SQL
> Server-DMO ODBC SQL State 4300..."
> I don't know if it has something to do with this but my SQL Server 2000 is
> setup for "SQL Server and Windows Authentication" Any idea?
> Thanks!
>
> "Carlos Eduardo Rojas" <carloser@.mindspring.com> wrote in message
> news:OPW6Vio5DHA.1632@.TK2MSFTNGP12.phx.gbl...
example:[QUOTE]
to[QUOTE]
in[QUOTE]
>

No comments:

Post a Comment