Browse by Tags

All Tags » access   (RSS)
Control metada visibility using few 'simple' statements
09 August 07 03:03 AM | SQL Master | 2 Comments   
You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the Read More...
Restrict Access to SQL Server using "Certificates"
02 July 07 02:07 AM | SQL Master | 1 Comments   
Within SQL Server 2005 you could take help of certificates to restrict the access from a particular client's machine. Few times (even me) confused with or get an impression that SSL encryption is same, for more information on SSL( Secure Sockets Layer) Read More...
Script to check user access on master and associated user database
28 May 07 10:16 AM | SQL Master | 0 Comments   
SELECT name , principal_id , type_desc , is_disabled , default_database_name , default_language_name FROM sys.server_principals WHERE name = 'login_name' go SELECT name , database_id , user_access_desc , state_desc , is_in_standby FROM sys.databases WHERE Read More...
Filed under: , , ,