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

db_SProcReader role generator Expand / Collapse
Author
Message
Posted Thursday, July 24, 2008 5:20 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 1, 2013 7:40 AM
Points: 145, Visits: 336
Comments posted to this topic are about the item db_SProcReader role generator

Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help
Post #540618
Posted Wednesday, October 8, 2008 4:20 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:36 PM
Points: 2,871, Visits: 3,060
You could also grant VIEW DEFINITION to the dbo schema or any other schemas in the database.


USE [DATABASENAME]
GO
GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [USER]
GO
Post #582979
Posted Thursday, October 9, 2008 8:03 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 1, 2013 7:40 AM
Points: 145, Visits: 336
Edogg (10/8/2008)
You could also grant VIEW DEFINITION to the dbo schema or any other schemas in the database.


USE [DATABASENAME]
GO
GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [USER]
GO


ahaa!!
Dont know why I didnt think of this, makes it much much simpler.
I will try to recreate this script using Schema's.
thanks
shiva


Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help
Post #583328
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse