Application roles

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Prashant Thakwani
    #1

    Application roles

    Can anybody tell, how to implement the application roles in SQL Server
    2000.

    Basically, I want to Implement the application roles in our
    application, so that it can be application specific. Its' an clients
    requirement from we people.

    Thanks

    Prashant Thakwani
    Tags: None
    • Simon Hayes
      #2
      Re: Application roles

      thakwani@rediff mail.com (Prashant Thakwani) wrote in message news:<bf0d42bf. 0403032120.588f b947@posting.go ogle.com>...[color=blue]
      > Can anybody tell, how to implement the application roles in SQL Server
      > 2000.
      >
      > Basically, I want to Implement the application roles in our
      > application, so that it can be application specific. Its' an clients
      > requirement from we people.
      >
      > Thanks
      >
      > Prashant Thakwani[/color]

      1. Create the role with sp_addapprole
      2. Grant permissions to the role with GRANT
      3. Use sp_setapprole to activate the role - you now have the role's
      permissions, not your own permissions
      4. Code your application to use sp_setapprole

      There are examples for these commands in Books Online - are you having
      a specific problem implementing them? If so, perhaps you could give
      more information about what commands you're using, what errors or
      unexpected behaviour you see etc.

      Simon

        Comment

        Previous template Next
        Working...