- Data and Records
- Stored Procedures
- Other SQL commands
- Syntax Definitions
- SQL standads overview
- Links to software manyfacturers documentation pages
- Copyright and Warranty
With GRANT you can give following rights or privileges to database users or roles (groups of users):
SELECT - revtrieve or query data
INSERT - insert new records into a table
UPDATE - modify datafields in a table
DELETE - delete records from a table
ALL - means all rights on a table
When PUBLIC is used instead of a list of concrete users or roles, then the specifyed priviledges will be given to all users of the database system (depending on the used RDMBS the rights are given only to the users woth connect permission to the current database).
WITH GRANT OPTION allows users to delegate their table priviledges to other users.
GRANT SELECT ON tkunden TO my_user;
The user my_user becames the priviledge to query, to retrieve data from the table tkunden.