How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
OMBLIST ROLES → Purpose To list existing roles or list existing roles whose names match the given regular expression or list the granted roles of a given user.
Table 4-3 Oracle Database Predefined Roles → the DBA_SYS_PRIVS data dictionary view. Note: Oracle recommends that you design your own roles for … that you design your own roles for database security rather than relying on this role. This role may … tables SYS.INCVID, SYS.INCFIL, and SYS.INCEXP. Also the following roles: EXECUTE_CATALOG_ROLE and … DBA_SYS_PRIVS to view privileges)
Predefined Roles in an Oracle Database Installation → Figure 4-1 Common Uses for Roles Description of ''Figure 4-1 Common Uses for Roles'' Common Uses of … Application Roles Grant an application role all privileges necessary to run a given database … application. Then, grant the secure application role to other roles or to specific users. An application … can have
Associating Privileges with User Database Roles → contains: Why Users Should Only Have the Privileges of the Current Database Role Using the SET ROLE Statement to Automatically Enable or Disable Roles
Finding Information About User Privileges and Roles → privileges and roles. See Oracle Database Reference for detailed information about these views.
Revoking Privileges and Roles from a User → This section contains: Revoking System Privileges and Roles Revoking Object Privileges Cascading Effects of Revoking Privileges
Granting a User Privileges and Roles → This section contains: Granting System Privileges and Roles Granting Object Privileges Granting … Privileges on Columns It is also possible to grant roles to a user connected through a middle tier or
CREATE TRIGGER Statement → than acquired through roles. Syntax create_trigger::= Description of the illustration … roles or object privileges to another user or to a role. NOAUDIT Causes the database to fire the … trigger whenever a REVOKE statement removes system privileges or roles or object privileges from a
Prerequisites → Warehouse Builder users can be list from any context.
Syntax → parseListRole = OMBLIST ROLES ( [ \"QUOTED_STRING\" | ( OF USER \"QUOTED_STRING\" ) ] )
Parameters → parseListRole This clause lists existing roles or lists existing roles whose names match the given … regular expression or lists the granted roles of a given user.
CREATE TYPE Statement → owner cannot obtain these privileges through roles. If the type owner intends to grant other users
About Granting Roles Using the Operating System or Network → Instead of a security administrator explicitly granting and revoking database roles to and from … roles to users at connect time. Roles can be administered using the operating system and passed to … Oracle Database when a user creates a session. As part of this mechanism, the default roles of a user … and the
Listing Information About the Privilege Domains of Roles → about the privilege domains of roles. For example, the following query lists all the roles granted to
To grant privileges and roles to the user Nick: → Toward the top of the Create User or Edit User page, click Roles to display the Roles subpage. The … Roles subpage shows that the CONNECT role is assigned to Nick. Database Control automatically … .) Click Edit List. The Modify Roles page appears. Description of the illustration modify_roles.gif … In the Available
Table 4-2 Properties of Roles and Their Description → the role. Selective availability of privileges You can selectively enable or disable the roles … awareness The data dictionary records which roles exist, so you can design applications to query … the dictionary and automatically enable (or disable) selective roles when a user attempts to execute … often create roles
Required Roles for Data Pump Export and Import Operations → role and/or the DATAPUMP_IMP_FULL_DATABASE role. These roles are automatically defined for Oracle … the names of these roles contain the word FULL, these roles are actually required for all export and … SQLFILE parameter. These roles allow users performing exports and imports to do the following … ) that unprivileged
Restricting SQL*Plus Users from Using Database Roles → roles and thus, prevent serious security problems. Potential Security Problems of Using Ad Hoc Tools … Limiting Roles Through the PRODUCT_USER_PROFILE Table Using Stored Procedures to Encapsulate Business … control the potential actions of a user, including the enabling and disabling of user roles while … granted to him explicitly
Granting and Revoking Roles When OS_ROLES Is Set to TRUE → and revoking of roles to users. Any previous granting of roles to users using GRANT statements do … at the operating system level apply. Users can still grant privileges to roles and users. Note: If … the operating system grants a role to a user with the ADMIN option, then the user can grant the role only to other roles.
Granting Roles Using the Operating System or Network → This section contains: About Granting Roles Using the Operating System or Network Using Operating … System Role Identification Using Operating System Role Management Granting and Revoking Roles When … OS_ROLES Is Set to TRUE Enabling and Disabling Roles When OS_ROLES Is Set to TRUE Using Network Connections with Operating System Role