permissions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » permissions

12 posts, Page 2 of 2

««1 2

permissions

Rate Topic

Display Mode

Topic Options

Author

Message

Vishal Singh

Posted Tuesday, September 22, 2009 1:17 AM

Old 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

Imran Ashraf-452633

Posted Wednesday, September 23, 2009 2:09 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 2:54 AM
Points: 1,103, Visits: 411

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 »

12 posts, Page 2 of 2

««1 2

Permissions