When created database in Microsoft SQL Server, many no. of default objects will be created.
when executed the command "sp_tables", so many no.of system tables will appear in addition to our own created tables. How to Hide them?
If you mean viewing in EM
From:
http://vyaskn.tripod.com/sql_server_tools_faq.htm#q2
How to hide/show system tables and other system objects in SQL Server Enterprise Manager?<top> |
Open Enterprise Manager. Right click on your server name and choose 'Edit SQL Server Registration properties...' from the popup menu. This presents the 'Registered SQL Server Properties' dialog box. In the bottom half of this dialog box, there is a check box against 'Show system databases and system objects'. Check it to show system databases/tables or uncheck it to hide system databases/tables.
But:
I think (I can be wrong too) that sp_tables itself shows the tables that user can access. So I suppose there could be some ways with permissions to restrict the access (roles etc)
No comments:
Post a Comment