Hi,

 

I wonder if anyone knows how I can retrieve all schemata on which a user has been granted permissions/authorization.  I have checked most of the hinting tables I get from querying

>> select id, name, schema_id, query from sys.tables where system = true;

 

but I have had no luck with that.  I only get the default schema for every user when I perform the following:

>> select * from sys.users

 

Any ideas or suggestions are welcome.

 

Thanks!

 

Luis Ángel.

The information transmitted, including any attachments, is intended only for the individual or entity to which it is addressed, and may contain confidential and/or privileged information. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by individuals or entities other than the intended recipient is prohibited, and all liability arising therefrom is disclaimed. If you have received this communication in error, please delete the information from any computer and notify the sender.