"Eirik Kongsvik" <ei***@jdata.no> wrote in message
news:f4**************************@posting.google.c om...
I want to make a user ho have the same rights as the SA user.
I have tried to use
Sp_addlogin
and sp_grantdbaccess
I have got a new user but i have only access to master DB. I can use
sp_grantdbaccess 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 "administrator" rights to every
database?
To give another login the same rights as sa, you can add them to the
sysadmin server role:
exec sp_addsrvrolemember '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