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...
> 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,
> 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...
> 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...
> > 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,
> > Alex
> >
> >
>|||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...
> 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...
> > 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...
> > > 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,
> > > Alex
> > >
> > >
> >
> >
>