Results 1 to 2 of 2

Thread: User permissions on SQL Server

  1. 04-09-2004, 05:10 AM #1
    ignas
    ignas is offline Registered User
    Join Date
    Feb 2004
    Posts
    17

    User permissions on SQL Server

    How to get user permissions without using SETUSER & PERMISSIONS combination. I've only database on server with db_owner rights. I can't perform those operations unless I'm in sysadmin. Help....
    Reply With Quote Reply With Quote
  2. 04-09-2004, 08:11 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Are you trying to get privileges granted to a user?

    You can get that querying

    information_schema.table_privileges

    or using sp_helprotect
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules