July 24, 2008 at 5:20 pm
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[/url]
October 8, 2008 at 4:20 pm
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
GO
October 9, 2008 at 8:03 am
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
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[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply