Thursday, 13 June 2013

Grant View Definition Permission - SQL Server



To Grant View Definition Permission to a User or Role in SQL Server

To turn on this feature across the board for all databases and all users you can issue the following statement:
USE master
GO
GRANT VIEW ANY DEFINITION TO PUBLIC
To turn on this feature across the board for all databases for user "User1" you can issue the following statement:
USE master
GO
GRANT VIEW ANY DEFINITION TO User1
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)