Can's see Server objects unless i'm dbo

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Fisher - 20 Feb 2006 02:14 GMT

I have created 2 databases on a SQL Server 2000 and use one for developement.
I have been successful on the developement database in createing all the SP's,
UDF's and Views and just this weekend created all the users and groups and
all works just fine until I switch to the production database. Now I can't
see and tables, or any objects in the Query pane unless I put my test user
login under the db_owners role. I have compared both databases till my eyes
are bleeding but can't see any difference between the two. I tried deleting
the login and recreating it but still when connected to the developement
database I can see everything and all forms work perfectly, when I connect to
the production database, some forms won't display subforms and I can't see
the tables or other server objects. I'm at my wits end here, has anyone ever
seen this? Thanks for any help.

using Access 2000 and SQL Server 2000

Reply to this Message

Alan Fisher - 20 Feb 2006 18:16 GMT

Problem Solved!!!! I didn't have the SYSOBJECTS table checked to allow select
so permission for non sysadmin users was implicitly (I think) denied. Once I
checked it they could see them. Now I think unchecking it will be a good
thing. As for the subform not showing data that I'm sure will be another
oversight I will have to find.

>I have created 2 databases on a SQL Server 2000 and use one for developement.
>I have been successful on the developement database in createing all the SP's,
[quoted text clipped - 10 lines]
>
>using Access 2000 and SQL Server 2000

Reply to this Message