Making a User in MSDE

[Eirik Kongsvik]

I want to make a user ho have the same rights as the SA user.

I have tried to use

Sp_addlogin
and sp_grantdbacces s

I have got a new user but i have only access to master DB. I can use
sp_grantdbacces s to every database.

Inn this case i have about 100 different databases i need to have
access to. is't a way to give a user "administra tor" rights to every
database?

[Simon Hayes]

Re: Making a User in MSDE


"Eirik Kongsvik" <eirik@jdata.no > wrote in message
news:f4367b2b.0 312160659.197df 131@posting.goo gle.com...[color=blue]
> I want to make a user ho have the same rights as the SA user.
>
> I have tried to use
>
> Sp_addlogin
> and sp_grantdbacces s
>
> I have got a new user but i have only access to master DB. I can use
> sp_grantdbacces s to every database.
>
> Inn this case i have about 100 different databases i need to have
> access to. is't a way to give a user "administra tor" rights to every
> database?[/color]

To give another login the same rights as sa, you can add them to the
sysadmin server role:

exec sp_addsrvroleme mber 'MyLogin', 'sysadmin'

Don't forget that sysadmins can do anything in SQL Server - if you want to
make a login db_owner for each database, then you will need to loop through
the databases, granting access to each one, then adding the user to the
db_owner database role.

Simon