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.
| Author |
Topic |
|
jreynolds
Starting Member
3 Posts |
 Posted - 2007-11-08 : 11:05:48
|
| I'm trying to identify the objects in master that the role public has select permissions on, but when I run this query, I get 4 results where the default schema is null and the major_id column does not correspond to any records in the sys.all_objects table. Where else can I look to find what objects these are. DBO is listed as the grantor.I appreciate your help.SELECT *FROM SYS.DATABASE_PERMISSIONS P, SYS.DATABASE_PRINCIPALS RWHERE P.GRANTEE_PRINCIPAL_ID=R.PRINCIPAL_ID and permission_name='SELECT' and class_desc='OBJECT_OR_COLUMN' and r.name='public'order by r.name desc |
|
|
jreynolds
Starting Member
3 Posts |
Posted - 2007-11-09 : 07:54:29
|
| It turns out to be a bug in sql 2005. Some orphaned database permissions rows"The bug exists because some of the system objects in Shiloh changed, but according to the team in charge of this code, there shouldn’t be any side effects other than the extra (pretty much orphaned) rows in the catalog view, but if you detect any unexpected behavior related to this bug please let us know." |
 |
|
|
|
|
|
Object Permissions, can't find