Authorisations - privileges, PL-SQL Programming

Authorisations - Privileges

As relational theory is silent on the issue of authorisation, it offers nothing with which SQL's vast edifice in support of what it calls privileges can be compared.Example is a very simple case showing how the corresponding example could be done in SQL.

 Example: Granting privileges GRANT SELECT, INSERT, DELETE, UPDATE ON ENROLMENT TO User9 ;

Explanation:

  1. GRANT is the key word indicating that privileges are being granted.
  2. SELECT, INSERT, DELETE, UPDATE identify operators that can be applied to a base table. The first, SELECT, is used here to indicate that permission to access the current value is being granted. The others are all update operators with very much the same effects as their counterparts in Tutorial D. If DELETE were omitted, for example, then User9 would not be allowed to use DELETE commands on ENROLMENT.
  3.  ON ENROLMENT identifies the base table on which those privileges are being granted.
  4. TO is the key word required to precede the commalist of user names, officially termed authorization identifiers, denoting the users on whom the specified privileges are to be conferred.

So, the example actually grants four distinct privileges.

Posted Date: 1/18/2013 1:26:49 AM | Location : United States







Related Discussions:- Authorisations - privileges, Assignment Help, Ask Question on Authorisations - privileges, Get Answer, Expert's Help, Authorisations - privileges Discussions

Write discussion on Authorisations - privileges
Your posts are moderated
Related Questions
Hi,am developing a library system and relating all the table is somehow complex,could you kindly assist me

IN Mode An IN parameter pass the values to the subprogram being called. Within the subprogram, an IN parameter acts like a constant. And hence, it cannot be assigned a value.

Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference

Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

COMMIT Statement The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered e

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

Ensuring Backward Compatibility   The PL/SQL Version 2 permits some abnormal behavior which Version 8 disallows. Particularly, Version 2 permits you to (i) Make the forw

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Loop Labels Like the PL/SQL blocks, loops can also be labeled. The label, an undeclared identifier enclosed by double angle brackets, should appear at the beginning of the LOOP