Can an owner give specific privileges on the owner's object to others?
An object owner can grant any object privilege on the object to any other user or role of the database.
To grant privileges on an object, the object must be in your own schema, or you must have been granted the object privileges WITH GRANT OPTION..
Can an owner give specific privileges on the owner's objects to others state?
An object owner can grant any object privilege on the object to any other user or role of the database.
To grant privileges on an object, the object must be in your own schema, or you must have been granted the object privileges WITH GRANT OPTION..
What system privilege must be held in order to login to an Oracle database?
No special privilege is needed; if your username exists in the database, you can login. 4.
The following table shows some of the output from one of the data dictionary views..
Which privilege is an object privilege?
An object privilege is the right to perform a particular action on an object or to access another user's object.
Objects include tables, views, materialized views, indexes, synonyms, sequences, cache groups, replication schemes and PL/SQL functions, procedures and packages..
Which statement would you use to grant a role to users?
The GRANT statement enables system administrators to grant privileges and roles, which can be granted to user accounts and roles.
These syntax restrictions apply: GRANT cannot mix granting both privileges and roles in the same statement.
A given GRANT statement must grant either privileges or roles..
- A schema is a collection of schema objects.
Examples of schema objects include tables, views, sequences, synonyms, indexes, clusters, database links, snapshots, procedures, functions, and packages.
Schema objects are logical data storage structures. - An object privilege is the right to perform a particular action on an object or to access another user's object.
Objects include tables, views, materialized views, indexes, synonyms, sequences, cache groups, replication schemes and PL/SQL functions, procedures and packages.