Deny viewing databases in SEM to non-admin accounts

From: Robbert Hof (robbert.hof@atosorigin.com)
Date: 01/07/03 

From: robbert.hof@atosorigin.com (Robbert Hof)
Date: 7 Jan 2003 07:17:57 -0800

Is it possible to let db-owners use the SQL Enterprise Manager without
showing all databases in the database-folder ?
I have tried to deny select-permissions on the sysdatabases table, but
this is overruled by the execute permissions on sp_MSdbuseraccess. I
can't revoke execute permissions on this procedure, because the
db-owner's own database is gone as well.

thanks,

Robbert

Relevant Pages

  • Re: Deny viewing databases in SEM to non-admin accounts
    ... Best you can do is hide the system databases and objects ... > Is it possible to let db-owners use the SQL Enterprise Manager without ... > this is overruled by the execute permissions on sp_MSdbuseraccess. ...
    (microsoft.public.sqlserver.security)
  • Re: Database files are "Hidden" after becoming Suspect
    ... Mike Epprecht, Microsoft SQL Server MVP ... > We had created some databases on the C Drive. ... > datafile the data file was not showing up. ...
    (microsoft.public.sqlserver.server)
  • Newbie Help!
    ... we are using Sharepoint POrtal server with a SQL ... and I notice the LDF is showing 0kb size. ... The msdb.mdf is also showing as suspect. ... The MDF's are on a RAID array with 270GB free space so the databases did not ...
    (microsoft.public.sqlserver.server)
  • Re: Suspect Databases and Hidden Attributes
    ... but also the OS was interpreting them as "Operating System Protected OS ... I was able to attach the data file using sp_attach_db but not using ... >> a reboot of the machine, the files of databases that were in Suspect mode ... >> I tried to attach the datafile the data file was not showing up. ...
    (microsoft.public.sqlserver.programming)
  • RE: Suspect Databases and Hidden Attributes
    ... > a reboot of the machine, the files of databases that were in Suspect mode ... > the same file in other location while I was trying to restore the databases. ... > those copies of these data files disappeared. ... > I tried to attach the datafile the data file was not showing up. ...
    (microsoft.public.sqlserver.programming)