Home Forums SQL Server 2008 T-SQL (SS2K8) can't view all db_users when select * from sys.databaseprincipals RE: can't view all db_users when select * from sys.databaseprincipals

  • Your DBA can create a signed stored procedure that runs with necessary permissions to allow the procedure to return to the user that data requested. I don't have the necessary info handy but I can get to it at home. I will try to post more tonight but not making promises as I have my daughter this week.