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

Ask an Expert

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

Write your message here..

Related Questions

Library system, Hi,am developing a library system and relating all the tabl... Hi,am developing a library system and relating all the table is somehow complex,could you kindly assist me

In mode - parameter modes, IN Mode An IN parameter pass the values to ... 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, Important Distinctions The list of important d... Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference

Other monadic - sql, Other monadic - SQL In 2VL there are just 4 (2 2 ... 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

Testing triggers, Demonstrate your knowledge of PL/SQL programming by writi... 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 in pl sql, COMMIT Statement The COMMIT statement expli... 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 in SQL Joining IS_CALLED and IS_ENROLLED_ON in... 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, Ensuring Backward Compatibility   The... 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 - fetch statement, Parameter and Keyword ... Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Loop labels- iterative control, Loop Labels Like the PL/SQL blocks, loop... 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