Viewing 2 posts - 1 through 2 (of 2 total)
thanks to all.
December 4, 2007 at 11:16 am
#757089
What is the difference between:
/* CREATE A NEW ROLE */
CREATE ROLE db_executor
/* GRANT EXECUTE TO THE ROLE */
GRANT EXECUTE TO db_executor
And
GRANT SELECT ON SCHEMA::SchemaName TO UserName
example: GRANT SELECT ON...
December 4, 2007 at 10:13 am
#757048