Enumerate the types of privileges available in SQL
Share
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.
There are two types of privileges.in SQL
1) System privileges – This allows the user to CREATE, ALTER, or DROP database objects.
2) Object privileges – This allows the user to EXECUTE, SELECT, INSERT, UPDATE, or DELETE data from database objects to which the privileges apply.
System privileges allow a user to perform a particular database operation or class of database operations.
While,
Objects have privileges associated with them, such as insert, update and delete a table.