Oracle Roles

Results 1 to 2 of 2

Thread: Oracle Roles

  1. #1
    Jason Guest

    Default Oracle Roles

    I need to use roles for a login to my application. I however am new to asp/oracle and am not sure how. If someone can help me incorporate roles into code, I would appreciate it. Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle Roles

    WHen you&#039;re working with Oracle, you really need the Oracle Complete Reference handy.<BR><BR>But in any case,<BR><BR>You define roles, grant rights to the roles, and assign the role to various users.<BR><BR>To create a role: create role manager<BR><BR>To grant privilege to role: grant select, delete on jobs to manager<BR><BR>To grant the role to a user: grant manager to billybob<BR><BR>To delete role: drop role manager

Posting Permissions

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