SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2011

Simple Database User-Access Security Validation & Granting Elevated Access Temporarily Using the Execute As Statement


If you ever want to validate what level of access a user has within a database OR wish to temporarily give elevated access to a database user’s object code (e.g. within a stored procedure) and not provide them directly with the privileges, you can profit from the Execute As Read more

0 comments, 1,108 reads

Posted in The Database Hive for SQL Server DBAs on 13 July 2011