How to hide INFORMATION_SCHEMA and sys from users
There's a system procedure that Crystal Reports (for example) invokes upon
connection to a SQL Server database: sp_schemata_rowset
In SQL 2005 this returns the three default Schemas:
dbo
INFORMATION_SCHEMA
sys
I'm trying to suppress/hide the last two Schemas but am not having any luck.
Is it possible to not expose Schemas to users in SQL 2005 (their existence
at all)? Revoke and Deny of various permissions does not seem to be working
(including View Definition which I thought would do it)...
TIA
--
Bill Blakey
.
Relevant Pages
- RE: SQLXMLBULKLOAD question: Does it INSERT only, or can it UPDATE as
... in SQL 2008 you can use the new MERGE statement. ... I have been opening up the Schemas in ... manually to the xsd file based on the diagram Visual Studio shows me. ... When we run the bulkload utility, ...
(microsoft.public.sqlserver.xml) - Re: Business objects, subset of collection
... we have schemas of objects (a set of rules that define the ... SQL works on not normalised data ... payment, please now execute their request payment routines (remember, ... That is why encapsulating is a bad thing in this case. ...
(comp.object) - Re: SSMS 2008: Object Explorer Details
... All of the schemas were owned by the user id that created them rather ... than being owned by dbo. ... Links for SQL Server Books Online: ...
(microsoft.public.sqlserver.tools) - Re: How to Generate Schema for Nested XML with SQL Adapter
... assemble the schemas. ... I think the best solution for your scenario will be create your own SQL ... use XML DOM bulk load. ... I have a query which is used to assemble nested XML from data base, ...
(microsoft.public.biztalk.general) - Re: Different databases or schemas?
... SQL 2000 and prior do not use schemas in the proper ANSI way. ... If you put the tables in a single database, remember that a database is a ... > single database but with different schemas? ...
(microsoft.public.sqlserver.server) |
|
