Since SQL Server 2005, a user/DBA can see definition of only those objects that he has permission to. Earlier versions of SQL Server were much more liberal in that respect. If you prefer that type of behavior on you server, you can issue a following command:
grant view any definition to public
Now, everybody can investigate all objects in a current database.
This may be a way to allow developers to investigate a production database without giving them ability to change anything. (It is better to do this then to make them database owners.)
ShareThis
No comments:
Post a Comment