Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Location
    DUBAI
    Posts
    6

    Unanswered: Sybase stored procedures permission

    hi friends,

    I would like to know how can we extract the permissions on all the Stored procedures of a sybase database. I know sp_helpprotect <procedure_name> will give the permissions on the specific sp. Is there any way to get permissions on sp on database level.

    -- akhilesh

  2. #2
    Join Date
    Feb 2012
    Location
    Pune
    Posts
    11
    check table sysprotects
    select object_name(a.id),user_name(a.uid),a.action from sysprotects a, sysobjects b
    where a.id=b.id
    and b.type ="P"

    check sysprotects description in
    SyBooks Online

Posting Permissions

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