Home Forums Programming SMO/RMO/DMO What happens if a user tries to execute some SMO object when they have low priorities? RE: What happens if a user tries to execute some SMO object when they have low priorities?

  • Another quick question; am I correct in believing that sys.server_principals and sys.server_role_members are system views that return data relevant to the server and not one of the databases? I'm wondering because we've defined the roles at the database level only. When I perform a SELECT * against both of those views I do not see our database roles at all. I do see server roles listed.

    I should mention that I'm doing this on a SQL Server 2008 R2 instance.

    Kindest Regards, Rod Connect with me on LinkedIn.