Re: Disable Sysadmin to view metadata in SQL2005

Hi Tim,

There's a SQL statement in 2005 that disables users view access of the
metadata. I think it's View Any Database / View Server State/ View
Definition. My question is that if we can disable SA account to view
the metadata (tables, columns, etc)?

Thanks,
Dex

Tim Stahlhut wrote:
There better not be an option to do that; it would be insane to do it.

Tim S

"Dex" <dplaras@xxxxxxxxxxx> wrote in message
news:1153253585.004826.199140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi Everyone,

Is there any way we can disable sysadmin/sa to view metadata on a
particular database in SQL2005?

Thanks,
Dex


.

Relevant Pages

  • Re: question?
    ... > question about the fedora project. ... If something like that (meaning the built in database ... of getting transactions to span filesystems. ... This is the metadata problem, or rather, series of problems. ...
    (Fedora)
  • Re: Question regarding to store file system metadata in database
    ... database, because the time used to read filelist and do statare ... considering the possibility of storing metadata in database. ... kernel boundary, I am expecting a moderate performance impact. ... the kernel to a userspace database process, ...
    (Linux-Kernel)
  • Re: Modelling objects with variable number of properties in an RDBMS
    ... >>> metadata during the early development stages, ... >>> then be used to build the final database system, ... >>> EAV model. ... > structured relational data model. ...
    (comp.databases.theory)
  • Re: Cool things you can do with Delphi
    ... >> To have code completion I am using MyGeneration to make classes for ... it's a matter of completing the metadata ... change in database to be reflected in code. ... TDataSet descendants to objects from DataExplorer and when an object from DE is ...
    (borland.public.delphi.non-technical)
  • Re: Metadata versioning
    ... > growing database applications as clients evolve with versions. ... to store the metadata version information. ... I created a set of classes to completely describe the metadata or schema ... catalog tables, and schema reading routines, I can move between metadata ...
    (borland.public.delphi.non-technical)