Results for privileges


121 to 160 of 2781 results. Prev  Next
Results per page:  20 |  40  | 60


Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Table 4-4 System Privileges for Named Typesrole includes the CREATE TYPE system privilege. The DBA role includes all of these privileges … . Object Privileges The only object privilege that applies to named types is EXECUTE. If the EXECUTE … any other stored PL/SQL procedure. See Also: \"Managing Procedure Privileges\" Privileges Required … system privilege

Database Security Guide, 11g Release 1 (11.1)

Managing Security for Application Developers

Table 5-3 SQL Statements Permitted by Database Object Privilegesobject (table, view, synonym, or snapshot) SQL statements using a sequence See \"About Privileges … and Roles\" for a discussion of object privileges. See also \"Auditing SQL Statements\" for detailed information about how SQL statements can be audited.

Database Security Guide, 11g Release 1 (11.1)

Keeping Your Oracle Database Secure

Enabling Default Auditing of SQL Statements and Privilegesstatements and privileges. Oracle recommends that you enable default auditing. Auditing is an … requirements, as defined in the Sarbanes-Oxley Act. See Also: \"Using Default Auditing for Security-Relevant SQL Statements and Privileges\"

Database Utilities, 11g Release 1 (11.1)

Original Export and Import

Verifying Access Privileges for Export and Import Operationsadministrators (DBAs). If you do not have the system privileges contained in the EXP_FULL_DATABASE

Providers for ASP.NET Developer's Guide, 11g Release 1 (11.1)

Oracle Providers for ASP.NET Installation

Database Privileges for SetupOracle Providers for ASP.NET requires the following privileges: Change notification Create job … script execution may indicate that the user needs to be granted the above privileges. If this is … the case, the database administrator must grant these privileges. The Oracle Session State Provider

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle Streams AQ Administrative Interface

8.4.3 Granting Queue PrivilegesVARCHAR2, grant_option IN BOOLEAN:= FALSE); This procedure grants privileges on a queue to users and roles … . The privileges are ENQUEUE, DEQUEUE, or ALL. Initially, only the queue table owner can use this … procedure to grant privileges on the queues. Caution: This procedure requires that EXECUTE privileges

XML DB Developer's Guide, 11g Release 1 (11.1)

Access Control Lists and Security Classes

Operation Description Privileges RequiredOracle XML DB Installation\" for information about treatment of database access privileges when upgrading

Real Application Clusters Administration and Deployment Guide, 11g Release 1 (11.1)

Oracle Real Application Clusters Tools Messages

PRKV-1063 \"Insufficient privileges.\"Cause: Action: Enter valid netmask in place of {0} before reattempting command. PRKV-1063 \"Insufficient privileges.\"

Real Application Clusters Installation Guide for Linux and UNIX, 11g Release 1 (11.1)

Oracle Application Express Postinstallation Tasks

5.6.1 Granting Connect PrivilegesThe following example demonstrates how to grant connect privileges to any host for the FLOWS_03000

Data Mining Application Developer's Guide, 11g Release 1 (11.1)

Building a Model

Mining Model Privilegesschemas if you have the appropriate system privileges. For example, CREATE ANY MINING MODEL enables you

XML DB Developer's Guide, 11g Release 1 (11.1)

Full-Text Search Over XML Data

Roles and PrivilegesTo run the examples you will need the CTXAPP role, as well as CONNECT and RESOURCE. You must also have EXECUTE privilege on the CTXSYS package CTX_DDL.

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Managing Oracle Streams AQ

Operation(s) Privileges Requiredprivileges needed. CREATE / DROP / MONITOR any queues Must be granted EXECUTE rights on DBMS_AQADM and be … rights on DBMS_AQ. No other privileges needed. ENQUEUE / DEQUEUE to another's queues Must be granted … EXECUTE rights on DBMS_AQ and be granted privileges by the owner using DBMS_AQADM … ANY QUEUE or DEQUEUE ANY QUEUE system

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle Streams AQ Administrative Interface

8.4.4 Revoking Queue PrivilegesVARCHAR2); This procedure revokes privileges on a queue from users and roles. The privileges are ENQUEUE … privileges propagated through the GRANT option are revoked if the grantor's privileges are revoked

OLAP User's Guide, 11g Release 1 (11.1)

Security

About the PrivilegesUsing both object security and data security, you can grant and revoke the following privileges … this privilege to refresh a dimension or cube. Users exercise these privileges either using

Data Mining Administrator's Guide, 11g Release 1 (11.1)

Users and Privileges for Data Mining

4 Users and Privileges for Data Miningthe use of database privileges. See Also: Oracle Database 2 Day + Security Guide for information … System Privileges for Mining Models Object Privileges on Mining Models

Data Mining Administrator's Guide, 11g Release 1 (11.1)

Users and Privileges for Data Mining

Creating Data Mining Userslogged in as a system administrator to create users and grant privileges. Note: To create a user that can

Data Mining Administrator's Guide, 11g Release 1 (11.1)

Users and Privileges for Data Mining

Privileges Required for Data MiningOracle Corporation recommends a set of basic privileges for data mining. The following GRANT … statements grant these privileges to a user named dmuser. GRANT create mining model TO dmuser; GRANT … models. The other privileges may not be required for some mining activities, however it is prudent to … and object privileges

Data Mining Administrator's Guide, 11g Release 1 (11.1)

Users and Privileges for Data Mining

System Privileges for Mining Modelsan action on a type of schema objects. For example, the privileges to create tablespaces and to … delete the rows of any table in a database are system privileges. To grant a system privilege, you must … ANY PRIVILEGE system privilege. The system privileges listed in Table 4-1 are required for performing … specific operations

Data Mining Administrator's Guide, 11g Release 1 (11.1)

Users and Privileges for Data Mining

Object Privileges on Mining Modelsprivilege. A user automatically has all object privileges for schema objects contained in his or her … role. Table 4-2 Object Privileges for Data Mining Object Privilege Allows you to.... ALTER MINING

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle Streams AQ Administrative Interface

8.4 Granting and Revoking PrivilegesThis section contains these topics: Granting Oracle Streams AQ System Privileges Revoking Oracle … Streams AQ System Privileges Granting Queue Privileges Revoking Queue Privileges

XML DB Developer's Guide, 11g Release 1 (11.1)

Access Control Lists and Security Classes

Database Privileges for Repository OperationsDatabase Privileges for Repository Operations Table 27-1 shows the database privileges required for … some common operations on resources in Oracle XML DB Repository. In addition to the privileges … listed in column Privileges Required you must have the resolve privilege for the folder containing the … resource

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle JMS Basic Operations

12.9 Granting and Revoking PrivilegesThis section contains these topics: Granting Oracle Streams AQ System Privileges Revoking Oracle … Streams AQ System Privileges Granting Publish/Subscribe Topic Privileges Revoking Publish/Subscribe … Topic Privileges Granting Point-to-Point Queue Privileges Revoking Point-to-Point Queue Privileges

Database Security Guide, 11g Release 1 (11.1)

Configuring Privilege and Role Authorization

Table 4-7 Data Dictionary Views That Display Information about Privileges and Rolesrole. DBA_ROLE_PRIVS Lists roles granted to users and roles DBA_SYS_PRIVS Lists system privileges … granted to users and roles SESSION_PRIVS Lists the privileges that are currently enabled for the user … about system privileges granted to roles. Information is provided only about roles to which the user has … access. ROLE_TAB_PRIVS

Database Security Guide, 11g Release 1 (11.1)

Using Oracle Virtual Private Database to Control Data Access

Which Privileges Are Used to Run Oracle Virtual Private Database Policy Functions?For greater security, the Oracle Virtual Private Database policy function runs as if it had been declared with definer's rights. Do not declare it as invoker's rights because this can confuse yourself and other users who maintain the code. See Also: Oracle Database PL/SQL Language Reference for detailed information about definer's rights

Database Security Guide, 11g Release 1 (11.1)

Managing Security for Application Developers

Why Users Should Only Have the Privileges of the Current Database Roleuser has only the privileges associated with the current database role. Consider the following … this scenario, an order entry clerk who was granted both roles can use the privileges of the ORDER

OLAP User's Guide, 11g Release 1 (11.1)

Getting Started with Oracle OLAP

Granting Privileges to DBAs and Application Developersprivileges. These privileges are different from those needed just to query the data stored in … the following roles and privileges. To create dimensional objects in the user's own schema … the owner of the dimensional objects needs SELECT object privileges on those tables. Example 2-1 shows

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle JMS Basic Operations

12.9.4 Revoking Publish/Subscribe Topic PrivilegesRevoking Publish/Subscribe Topic Privileges TopicSession t_sess; Topic topic; ((AQjmsDestination)topic).revokeTopicPrivilege(t_sess, \"ENQUEUE\", \"scott\");

Streams Concepts and Administration, 11g Release 1 (11.1)

Rules

Database Objects and Privileges Related to RulesDBMS_STREAMS_ADM package. You control the privileges for these database objects using the following … the user's own schema, grant the user the following system privileges: CREATE_RULE_SET_OBJ … CREATE_RULE_OBJ CREATE_EVALUATION_CONTEXT_OBJ These privileges, and the privileges discussed in the following … : Privileges

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle Streams AQ Administrative Interface

8.4.1 Granting Oracle Streams AQ System PrivilegesBOOLEAN:= FALSE); This procedure grants Oracle Streams AQ system privileges to users and roles. The … privileges are ENQUEUE_ANY, DEQUEUE_ANY, MANAGE_ANY. Initially, only SYS and SYSTEM can use this … on any schemas in the database. Example 8-37 Granting AQ System Privileges BEGIN

Ultra Search Administrator's Guide, 11g Release 1 (11.1)

Security in Oracle Ultra Search

Classes of Users and Their PrivilegesTo grant an Oracle Ultra Search user administration privileges, you must assign the user to an … instances for which they have privileges. Super-use rs: Users in this group can manage all instances … , including creating instances, dropping instances, and granting privileges. Oracle Ultra Search users … database. WK SYS: This

Warehouse Builder Installation and Administration Guide for Windows and UNIX, 11g Release 1 (11.1)

Troubleshooting a Warehouse Builder Installation

SYS user does not have SYSDBA privileges.Cause: In a standard database installation, the SYS user has SYSDBA credentials and REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE. You can verify the credentials by issuing the following connect statement: SQL> CONNECT sys@tns_name_of_db AS SYSDBA; Enter password: sys_password If your database is configured with REMOTE_LOGIN_PASSWORDFILE=NONE, then the statement fails. Action: If the statement fails, then you

Streams Concepts and Administration, 11g Release 1 (11.1)

Rule-Based Transformations

Required Privileges for Custom Rule-Based TransformationsThe user who calls the transformation function must have EXECUTE privilege on the function. The following list describes which user calls the transformation function: If a transformation is specified for a rule used by a capture process, then the capture user for the capture process calls the transformation function. If a transformation is specified for a rule used by a synchronous capture, then the

Label Security Administrator's Guide, 11g Release 1 (11.1)

Administering and Using Trusted Stored Program Units

11.2 Managing Program Unit Privileges with SET_PROG_PRIVSTo grant privileges to a stored program unit, you must have the policy _DBA role, and the EXECUTE … Enterprise Manager to manage Oracle Label Security privileges. Use the SA_USER_ADMIN. SET_PROG_PRIVS … procedure to set policy-specific privileges for program units. If the privileges parameter is NULL, then … the

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle Streams AQ Administrative Interface

8.4.2 Revoking Oracle Streams AQ System Privilegesrevokes Oracle Streams AQ system privileges from users and roles. The privileges are ENQUEUE_ANY … database. Example 8-38 Revoking AQ System Privileges BEGIN DBMS_AQADM.REVOKE_SYSTEM_PRIVILEGE( privilege => 'DEQUEUE_ANY', grantee => 'test'); END; /

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Managing Oracle Streams AQ

4.7.1 EXECUTE Privileges Required for Propagationtable owner must be granted EXECUTE privileges on the DBMS_AQADM package. Otherwise, the Oracle Database

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle JMS Basic Operations

12.9.1 Granting Oracle Streams AQ System Privilegesadmin_option) throws JMSException This method grants Oracle Streams AQ system privileges to a user or … calls on any schemas in the database. Example 12-18 Granting Oracle Streams AQ System Privileges

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle JMS Basic Operations

12.9.2 Revoking Oracle Streams AQ System PrivilegesJMSException This method revokes Oracle Streams AQ system privileges from a user or role. It has the … Privileges TopicSession t_sess; ((AQjmsSession)t_sess).revokeSystemPrivilege(\"ENQUEUE_ANY\", \"scott\");

Streams Advanced Queuing User's Guide, 11g Release 1 (11.1)

Oracle JMS Basic Operations

12.9.3 Granting Publish/Subscribe Topic Privilegesprivileges on the topic. It has the following parameters: Parameter Description session JMS session … privilege to other users or roles Example 12-20 Granting Publish/Subscribe Topic Privileges TopicSession

Streams Concepts and Administration, 11g Release 1 (11.1)

Rules

Privileges for Using an Evaluation ContextPrivileges for Evaluating a Rule Set To evaluate a rule set, a user must meet at least one of the … privilege specified WITH GRANT OPTION on all rules currently in the rule set. Privileges for Using an

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

New Features

SYSDBA/SYSOPER Privileges in CONNECT StatementsTo set these privileges using the CONNECT statement, see \"Connect to the Database\".





Was this page helpful?

Integrated Cloud Applications & Platform Services