Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    96

    Unanswered: how to know about the object level privilages

    hi all
    I just want to know that how do i find which users have create objects privilages. As by sp_helpprotect<object_name> we can only know about the permissions on a particular object.But how do i know which users have which create objects permissions.
    Plz let me know
    thanks in advance for the help

  2. #2
    Join Date
    Mar 2008
    Location
    Paris
    Posts
    5
    Hi,

    You can look into the sysprotects table using the uid of the user. The action column has a code you can also look for (198 for create table).

    Philippe

  3. #3
    Join Date
    Mar 2008
    Posts
    96
    Thanks a lot

Posting Permissions

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