Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Followup to: GRANTing permissions...

Re: Followup to: GRANTing permissions...

From: Daniel Benson <dbenson_at_us.oracle.com>
Date: Wed, 26 Aug 1992 17:21:15 GMT
Message-ID: <1992Aug26.172115.4668@oracle.us.oracle.com>

George,

ORACLE7 Roles can be dependent on Unix groups. That is if you are in a specificUnix group you can be default be in specific Roles. Below is a short description from the ORACLE7 DBA Guide about Roles:

The ORACLE RDBMS provides for easy and controlled privilege management through the use of roles. Roles are named groups of related privileges that are granted to users or other roles. The following properties of roles allow for easier privilege management:

Roles are often created for a database application. An application role is granted all privileges necessary to run the application. The application roll is then granted to other roles or users. An application can have several different roles, each granted a different set of privileges that allow for more or less data access while using the application.

A role can be created with a password to prevent unauthorized use of the privileges granted to the role. Typically, an application is designed so that when it starts, it enables the proper role. As a result, an application user does not need to know the password for an application's role.


Hope this helps, -d Received on Wed Aug 26 1992 - 12:21:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US