Why can not I see the sys objects? of SQL Server?

Navigation
1

Good afternoon,

I have a concern, I do not know why I can not see the views belonging to the "sys" schema, so the following error came up:

... when I made this query: 

SELECT * FROM master.sys.database_permissions AS dp   
JOIN sys.system_objects AS so  
ON dp.major_id = so.object_id  
WHERE dp.class = 1 AND so.parent_object_id = 0 ;  
GO

And because it is bringing me problems with larger codes, even in the Management Studio browser the views with sys schema do not appear. (Sys.table example) only those with dbo schema appear.

What do you think is due?

Any suggestions would be very grateful.

    
asked by Fran.J 27.01.2017 в 21:49
source

1 answer

1

I think the problem is simply permissions, grant permissions on sys.database_permissions : 

USE master
GRANT SELECT ON sys.database_permissions TO <usuario>
GRANT CONTROL SERVER TO <usuario>
GO
    
answered by 27.01.2017 в 22:27
Problems signing XML with C # Error adding ForeignKey in Oracle