Grant description:
Name
Grant-grant access permissions to a user, a group, or all users Grant privilege [,...] OnObject[,...] To {public|Group|Username}
Input
Privilege may have the following permissions:
Select: access all columns/fields in the declared table/view.
Insert: insert all column fields into the declared table.
Update: update all declared columns/fields.
Delete: delete all rows from the declared table.
Rule: Defines rules on tables/views (see create rule Statement ).
ALL: grant all permissions.
ObjectName of the object to be granted permissions. Possible objects are:
* Table)
* View)
* Sequence)
* Index)
Public:
Represents the abbreviation of all users.
Group group:
The group to be granted permissions. In the current version, the Group must be explicitly created using the following method.
Username:
The username to be granted. Public is short for all users.
Output
Change: If successful, this message is returned.
Error: changeacl: Class "object" not found
If the declared object is unavailable or it is impossible to grant permissions to the declared group or user.
Example
Insert record permissions to table films for all users: Grant insert on films to public;
grant all permissions to the Manuel operation view kinds:
code highlighting produced by actipro codehighlighter (freeware)
http://www.CodeHighlighter.com/
--> grant all on kinds to Manuel;
Restrict all rights in cmeip to Doc Spool c: \ grant. SQL
Select'Grant all on'|Tname|'To Doc'From tab;
Open the statement c: \ grant. SQL except grant
@ C: \ grant. SQL
Revoke description:
Revoke -- delete the access permission. Revoke {select | Insert | Update | Delete | Rule | References | Trigger}
[,...] | All [privileges]}
On [Table] Object [,...]
From {Username | Group groupname | Public} [,...]
revoke {execute | All [privileges]}
On Function funcname ([type,...]) [,...]
from {username | group groupname | Public} [,...]
Revoke {usage|All [privileges]}
On Language langname [,...]
From {Username|Group groupname|Public} [,...]
Description
Revoke allows the creator of an object to revoke the permissions granted to one or more users or a group of users. the public keyword indicates the implicitly defined group with all users.
Please note that any specific user will have the permissions directly granted to him/her, plus any group of him/her, and the total permissions granted to public. therefore, for example, abolishing the public select permission does not mean that all users lose the select permission on the object: those who directly obtain the permission and who obtain the permission through a group still have this permission.
Example
Revoking the public's insert permission on the table films: Revoke insert on films from public;
Revoke all permissions of Manuel on The View kinds: Revoke all privileges on kinds from Manuel
Auto: http://hi.baidu.com/higaea/blog/item/e02be13f0e8842c67d1e71a0.html