Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Upgrade to SQL 2008, Role permissions not working.

Author  Topic  JonAus Starting Member 1 Post Posted - 2010-01-15 : 19:31:10 I have a SQL 2008 permissions related issue which is currently driving me crazy. A DB restored, from a SQL 2000 or 2005 server onto my 2008 server, when I port the logins to the SQL box and match them up, the Non DB_OWner users, cannot see any of the objects in my three main schema's. We have roles for the schema's which provide access to the tables within them, but when a non DB_Owner user logs into Management Studio, and expands the list of tables, only a handful of DBO tables appear. Granting access to the tables, has allowed us to work with the tables in queries, but we still cannot see them in the listing in Management Studio. Stored Procedures however, still refuse to execute.. I tried creating a new DB on 2008, from scripts, but I get the same issues. Does anyone know of a change to the role based security which would block access to other schema's, even if the users role provided access for them to get to it. Thanks, Jon