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