Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    47

    Unanswered: verify sybase role within a procedure

    I need to write either a function or stored procedure which verifies if someone has a particular role before they can see a report.

    I was thinking I would call ‘SP_DisplayRoles’ from a procedure but I can't seem to get it to work. Any ideas?


  2. #2
    Join Date
    Apr 2006
    Location
    Johannesburgh
    Posts
    8
    hi
    check out this
    there is a check for roles in there

    http://www.sypron.nl/grant_sa.html

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    if you are looking for a specific role then you can use;

    select proc_role("sa_role")
    go

    -----------
    1

    select proc_role("non_existant_role")
    go

    -----------
    0

Posting Permissions

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