Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

types of Privileges are available in SQL ?
#1

Hello Dear,

Please Tell Me How many types of Privileges are available in SQL ?
Reply
#2

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.
Reply
#3

Hi Friend,
A privilege in SQL allows a subject (authorization identifier) to execute a set of actions on a given SQL object.

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.
Reply


Possibly Related Threads...
Thread / Author Replies Views Last Post

Forum Jump:


Users browsing this thread: 1 Guest(s)