Oralce grant permission and reovke deny permission usage

Source: Internet
Author: User
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.


Object
Name 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.