schema, login account permissions

  • Want to gather a report to find what are all the schema a specific login account have along with that what are all the specific object level permission does it have.

    If you have any specific easy script do share that with me.

    Thanks.

  • You are going to want to join sys.database_principals to sys.server_principals and sys.database_permissions and sys.database_roles in order to gather that information in every database you have.

    It's pretty trivial to write (not to mention a quick search will find scripts to help)



    Shamless self promotion - read my blog http://sirsql.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply