InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 15:45:26 GMT20http://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxYou are probably best creating DB roles and applying the permissions to that role, egUSE DBNamegoCREATE ROLE UPDATE_ROLEgoGRANT EXECUTE ON [dbo].SP TO [UPDATE_ROLE]goGRANT SELECT, DELETE, INSERT, UPDATE ON [dbo].[tblStartup] TO [UPDATE_ROLE]GOMakes sense to do this so you can add users to this role and only need to define the permissions once for the role and then add users to the role.Wed, 23 Sep 2009 02:09:59 GMTImran Ashraf-452633http://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxif you are a OKAY in scripting, you may like it.SP_MSFOREACHDBSP_MSFOREACHTABLETue, 22 Sep 2009 01:17:17 GMTVishal Singhhttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxthanks........i got it........Mon, 21 Sep 2009 01:55:51 GMTcharipghttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxIf you right click on the database select properties, look at permissions. you will see the user that you granted the select permission to.if you click on that user, then click on effective, you will see select there. as well as if yo8u click on explicit, scroll down to select and you will see grant is ticked.Mon, 21 Sep 2009 01:04:10 GMTSilverfoxhttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxyes, i cheked in GUI after excuting that query.Mon, 21 Sep 2009 01:03:36 GMTcharipghttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxhow did you test it, remember that allocating permissions this way, it will not show correctly in the GUI. but the permissions would have been allocatedMon, 21 Sep 2009 00:57:13 GMTSilverfoxhttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxits not working.Mon, 21 Sep 2009 00:54:14 GMTcharipghttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxThere are better ways of doing it butUSE [databasename]GOGRANT SELECT TO [username]try that and let me know if that works for you.Mon, 21 Sep 2009 00:47:17 GMTSilverfoxhttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxi want to give these permissions to all tables.Mon, 21 Sep 2009 00:41:20 GMTcharipghttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspx5oo tables are present in that db.so at a time how to give the permissions.?Mon, 21 Sep 2009 00:40:44 GMTcharipghttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspx[quote][b]charipg (9/21/2009)[/b][hr]how to provide the execute permissions to the stored procedures and select, update, delete rights on the tables to a perticular user?[/quote]As mentioned before in previous posts.GRANT EXECUTE to [loginname]will give execute permissions for procedures for that particular database.as for DML Permissionsit is better to do that at object level so,GRANT SELECT on [tablename] to [username]GRANT DELETE on [tablename] to [username]GRANT INSERT on [tablename] to [username]Mon, 21 Sep 2009 00:36:11 GMTSilverfoxhttp://www.sqlservercentral.com/Forums/Topic790952-146-1.aspxhow to provide the execute permissions to the stored procedures and select, update, delete rights on the tables to a perticular user?Mon, 21 Sep 2009 00:17:05 GMTcharipg