August 16, 2005 at 10:46 am
I have two non-SA users who can register our server and can use EM to see the "Databases" folder. They are both db owners of DatabaseA. However, though they see the "Databases" folder, EM says (no items) when they click on the folder. I was reguired to remove all permissions from public for all system tables. Could this be the problem? What system tables might they need to see to view the list of DAtabasese? I already added select permission to public to sysdatabases and sysobjects in master and there was no change.
August 17, 2005 at 5:10 am
If you want to restrict them from viewing all but the 1 database they have access to, you can grant select to the following tables in the database you want them to access.
sysforeginkeys
sysindexes
sysindexkeys
sysmembers
syspermissions
sysproperties
sysprotects
sysreferences
August 17, 2005 at 9:37 am
Double check that they are in "Users" list of the database. Sometimes this gets corrupted, and you have to drop the login & recreate it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply