0 0 Sandy1 Asked: October 31, 20212021-10-31T19:19:27+05:30 2021-10-31T19:19:27+05:30In: DBMS Enumerate the types of privileges available in SQL 0 0 Enumerate the types of privileges available in SQL Share Facebook 1 Answer Voted Oldest Recent Professor 2021-11-01T14:46:21+05:30Added an answer on November 1, 2021 at 2:46 pm 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. Leave an answerCancel replyYou must login to add an answer. Username or email* Password* Remember Me! Forgot Password?
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.