June 25, 2004 at 7:54 am
Can anyone explain why a SQL user would get "SELECT permission denied on object 'sysobjects'"
after defining that user with all the DB roles checked.
The user can create tables in query anayzer but can not see the tables in Enterprise Manage.
Steps taken:
1. Created Database as someone with SystemAdmn rights.
2. Gave the user Login Server role Database Creator
3. Gave user access to database with all DB roles checked.
4. In query analyzer that user can create table, etc....
5. However, in Enterprise Manager, connected to the server as that user, cannot display tables get - SELECT permission denied on object 'sysobjects'. Get same message as user in query analyzer when doing a select * from sysobjects.
June 25, 2004 at 12:12 pm
Do they get this when EM starts? Perhaps they do not have master access?
June 25, 2004 at 12:41 pm
The problem was that the 2 "deny" database roles were check. They were overiding the access.
Thanks.
Case closed.
June 30, 2004 at 7:37 am
you checked all the database roles?
including DENY_DATA_READER and DENY_DATA_WRITER
this sounds like the problem
you only need to grant them the single role of Database_owner and they have all the permissions you need.
remove all the others and you're laughing!
MVDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply