Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

permissions Expand / Collapse
Author
Message
Posted Tuesday, September 22, 2009 1:17 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:30 AM
Points: 353, Visits: 487
if you are a OKAY in scripting, you may like it.

SP_MSFOREACHDB
SP_MSFOREACHTABLE


-Forum Etiquette: How to post Performance Problems

-Forum Etiquette: How to post data/code to get the best help
Post #791540
Posted Wednesday, September 23, 2009 2:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:30 AM
Points: 1,115, Visits: 448
You are probably best creating DB roles and applying the permissions to that role,
eg
USE DBName
go
CREATE ROLE UPDATE_ROLE
go
GRANT EXECUTE ON [dbo].SP TO [UPDATE_ROLE]
go
GRANT SELECT, DELETE, INSERT, UPDATE ON [dbo].[tblStartup] TO [UPDATE_ROLE]
GO

Makes 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.
Post #792432
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse