|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
howto sp_adduserhey everyone,
i managed to sp_addlogin: sp_addlogin 'ID', 'PWD', 'ad_2000' then i tried to sp_adduser: sp_adduser 'ID', 'ID', 'sysadmin' and it threw an error: sysadmin does not belong to database i assume that i should have set the database to master but would that affect any access permissions to ad_2000 What you need is sp_addsrvrolemember. Look up the details in Books Online.
You are trying to add the login to the sysadmin server role, aren't you? Although I would urge you to consider possible consequences. What exactly are you trying to do? Why would this new user need all the privileges of a system administrator? ML thank you for your response
well, i added triggers to some tables right that will log any INSERT, UPDATES, DELETES to the table, so one of the things i log, is the user logged in to the database sa is the default, so i decided to add users for everyone, that way the log will work for whoever is logged in (making my life alot easier) they need the same privileges as sa so they can use the application thank you for your help Show quote "ML" <M*@discussions.microsoft.com> wrote in message news:82A12D8B-95E0-42B3-B6CD-BE382AA49786@microsoft.com... > What you need is sp_addsrvrolemember. Look up the details in Books Online. > You are trying to add the login to the sysadmin server role, aren't you? > > Although I would urge you to consider possible consequences. > > What exactly are you trying to do? Why would this new user need all the > privileges of a system administrator? > > > ML ty
Show quote "ML" <M*@discussions.microsoft.com> wrote in message news:0A8C1D08-25E4-4FC9-BE42-4C034ABD599E@microsoft.com... > This is the place to get help. :) > > > ML  |
|||||||||||||||||||||||
Other interesting topics