how to hide stored proc and tables schema

However, this works perfectly if the user is the owner of the database. Look

that …

• Create a new SQL login "login1"

• Create a user named “login1” in master database

• Grant CREATE DATABASE to login1

• While impersonating login1, create a database called “dbteste”

• Revoke CREATE DATABASE permission from login1

• Revoke VIEW ANY DATABASE permission from PUBLIC

• Register this server as login1

• From the “login1” session, expand database tree. Now, you should see

master, tempdb, dbteste

• Grant VIEW ANY DATABASE to PUBLIC

• From the “login1” session, you should see all the databases

---

Best Regards,Uri Dimant SQL Server MVP, http://ift.tt/1iQ9JkR



MS SQL optimization: MS SQL Development and Optimization

MS SQL Consulting: Large scale of database and data cleansing

Remote DBA Services: Improves MS SQL Database Performance

SQL Server Integration Services: Business Intelligence