SQL Server Performance

Let a user with minimal privileges see another user, simple with TSQL - SQL Server 2005

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Mar 11, 2008.

  1. Anonymous New Member

    You may be aware that by default, users that have minimal privileges cannot see other users in the sys.database_principals and sys.server_principals catalog views. This means that a user with minimal privileges that owns a table cannot see other users to whom the user might want to grant permissions. To let user user_X with minimal privileges see another user, user_Y , you can issue the following GRANT statement: GRANT VIEW DEFINITION ON USER :: &lt;user_Y&gt; TO &lt;user_X&gt; So to automate this...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/03/11/3710.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3710" width="1" height="1">

Share This Page