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

Mixed notation, Mixed Notation The fourth procedure call shows that yo... Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

Updating tables in sql, Updating Tables in SQL The topic of updating b... Updating Tables in SQL The topic of updating by describing the assignment operator, ":=" in Tutorial D. SQL uses a different syntax for assignment, using the key word SET and

Assignment 4, I need a query for PL/SQL, selecting names with cursor, goes ... I need a query for PL/SQL, selecting names with cursor, goes down the list, assigns usernames (initials001) based on initials in the name. If two names have same initials the user

Opening a cursor, Opening a Cursor Opening the cursor executes the que... Opening a Cursor Opening the cursor executes the query & identifies the result set that consists of all rows that meet the query search criteria. For the cursors declared usin

Left and right joins, Left and Right Joins LEFT OUTER JOIN can be used... Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

Types of evolution, TYPES OF EVOLUTION - Sequential evolution         ... TYPES OF EVOLUTION - Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the resul

Do you know anyone that can do this type of coding or not?, Task 2 [12 mark... Task 2 [12 marks] Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place

Authorize and fetch data from instagram, Authorize and fetch data from Inst... Authorize and fetch data from Instagram Project Description: Incorporate Instagram feed on mobile site platform: c#, ms sql, jquerymobile, jquery Web admin Author

Definition of cross join - sql, Definition of CROSS JOIN - SQL Let s ... Definition of CROSS JOIN - SQL Let s = t1 CROSS JOIN t2, where t1 and t2 are table expressions optionally accompanied by range variables. Then: Note: Here T denotes Table

Pits, PITS Depressions in secondary cell wall is called pit. A pi... PITS Depressions in secondary cell wall is called pit. A pit present on the free cell wall surface without its partner is called Blind pit. It consists of 2 parts -