What are the privileges that can be granted on a table by a user to others

What are the privileges that can be granted on a table by a user Toothers?

Ans: Alter, delete, index, insert, references, select, update.Execute is not a grantable privilege.
  • rajanipriya. Answered On : May 8th, 2006.
  • Alter, delete, index, insert, references, select, update. are the table(object)priviliges that can be granted by a user to others.

What are the privileges of a user?

A user privilege is a right to execute a particular type of SQL statement, or a right to access another user’s object. The types of privileges are defined by Oracle. Roles, on the other hand, are created by users (usually administrators) and are used to group together privileges or other roles.

What type of privileges can be granted?

The type of access granted can be any like, read-only, read, and write. Privilege means different Data Manipulation Language(DML) operations which can be performed by the user on data like INSERT, UPDATE, SELECT and DELETE, etc. There are two methods by which access control is performed is done by using the following.

Which command is used to set a set of privileges that can be granted to users or to other roles?

Object privileges can be granted to and revoked from users and roles. If you grant object privileges to roles, you can make the privileges selectively available. Object privileges can be granted to, or revoked from, users and roles using the SQL commands GRANT and REVOKE, respectively.

How many types of privileges are available in SQL?

There are two types of privileges: (a) System Privileges: This indicate user to CREATE, ALTER, or DROP database elements. (b) Object Privileges: This allows user to EXECUTE, SELECT, INSERT, or DELETE data from database objects to which the privileges apply. Roles are the collection of privileges or access rights.

What is meant by granting a privilege?

verb. If someone in authority grants you something, or if something is granted to you, you are allowed to have it.

What are the system privileges?

System privileges. A system privilege is the right to perform a particular action or to perform an action on any object of a particular type. Objects include tables, views, materialized views, synonyms, indexes, sequences, cache groups, replication schemes and PL/SQL functions, procedures and packages.

Which of the following are object privileges?

An object-level privilege is a permission granted to an Oracle database user account or role to perform some action on a database object. These object privileges include SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX on tables and views and EXECUTE on procedures, functions, and packages.

How do I add privileges to a role in Oracle Fusion?

Select a privilege or role. If you select a privilege, click Add Privilege to Role. If you select a role, click Add Selected Privileges.

What do you mean by privilege?

Privilege, prerogative refer to a special advantage or right possessed by an individual or group. A privilege is a right or advantage gained by birth, social position, effort, or concession.

Which command is used to give privileges to the user?

1. Grant : SQL Grant command is specifically used to provide privileges to database objects for a user. This command also allows users to grant permissions to other users too.

What are privileges in database?

A privilege is a right to execute a particular type of SQL statement or to access another user’s object. Some examples of privileges include the right to: Connect to the database (create a session) Create a table.

Which among the following are examples of privileged instructions?

(iv) Various examples of Privileged Instructions include:
  • I/O instructions and Halt instructions.
  • Turn off all Interrupts.
  • Set the Timer.
  • Context Switching.
  • Clear the Memory or Remove a process from the Memory.
  • Modify entries in the Device-status table.

Is education a privilege?

Education is not a privilege. It is a human right. … the right to education is legally guaranteed for all without any discrimination. states have the obligation to protect, respect, and fulfil the right to education.

Which statement is used to allow privileges on database to users Mcq?

Explanation: The privilege list allows the granting of several privileges in one command .

Which two actions can you perform with object privileges?

These object privileges include SELECT, INSERT, UPDATE, DELETE on tables and views and EXECUTE on procedures, functions, packages, and Java objects. They can be granted using Oracle Portal or using Oracle commands.

What are privileges in SQL?

A privilege is a right to execute a particular type of SQL statement or to access another user’s object. Some examples of privileges include the right to: Connect to the database (create a session) Create a table.
…
Schema Object Privileges
  • Table.
  • View.
  • Sequence.
  • Procedure.
  • Function.
  • Package.

What are MySQL process privileges?

According to the MySQL documentation, the PROCESS privilege controls access to information about statements being executed by sessions. It is a server administration privilege and should not be given to all users. This is because it may show text from currently executing queries.

What is global privileges in MySQL?

Administrative privileges enable users to manage operation of the MySQL server. These privileges are global because they are not specific to a particular database. Database privileges apply to a database and to all objects within it.
You May Also Like