September 22, 2004 at 11:54 am
I wanted to give my sql server user to give select,insert,update on all the tables and execute permission on all the stored procedures.He should get the permissions on the object which will be created in the future.How can i do this.
Thanks.
September 22, 2004 at 12:21 pm
there are couple of ways to do that. The easier way is create a user group and grant all permissions like select, delete or something on all tables without execution privilege, then assign users to this group. In case of any new tables created in the future, you only need to add it to that group with desired permissions. Any users belonging to this group should be granted with those permissions automatically.
September 22, 2004 at 5:07 pm
How about this:
Create a new database role and add your user to the role. Then add the new role to the existing db_datareader and db_datawriter database roles. That takes care of the table permissions. You can then grant EXECUTE on individual stored procedures to the new role.
You can do this in Enterprise Manager. The db_datareader and db_datawriter roles grant permission on all existing and future user tables in the database.
Greg
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply