May 7, 2003 at 9:21 am
I am in process of creating new users for our servers. There are couple of 100 db's and i need to assign read/write permissions to all db's. Can anyone help me with the proc for this purpose. say user ABC needs read/write permissions, and can this be done through a stored proc or script.
May 7, 2003 at 9:32 am
It can be through a script, but you need to know what you want. Which tables/views/procs need which rights, select, insert, update, delete, execute?
Also, I'd use Roles for this, not users. Assign the rights to a role (which can be created in a script) and then assign users to the roles.
Steve Jones
May 7, 2003 at 9:38 am
i just need a script that will assign database roles db_datareader and db_writer to the db. I mean the way we do using GUI to add . its time taking to do manually. though i have the idea but difficult to get through.
need the script to assign given user read/write db roles.
May 7, 2003 at 1:35 pm
Thanks for the information. I have got the script using database roles.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy