يك شنبه,۱۲ تير ماه ۱۴۰۱مطابق با
۳ ذيحجه ۱۴۴۳ هجرى قمرى

SQLPlus Security/Privileges
The SQL statements GRANT and REVOKE, respectively allow /disallow access.
GRANT {role | privilege_list ON object_name} TO user;
ROLE
ADMIN: CREATE SCHEMA, CREATE USER, ALTER USER, DROP USER, DROP SCHEMA, GRANT, and REVOKE
DBA/DDL: All ADMIN privileges, CREATE TABLE, CREATE ANY TABLE, CREATE VIEW, CREATE ANY VIEW, CREATE INDEX, CREATE ANY INDEX, ALTER TABLE, ALTER VIEW, DROP TABLE, DROP VIEW, and DROP INDEX.
RESOURCE: The RESOURCE role grants the same level of control as the DBA/DDL role, but only over the user’s own domain.
Example:CREATE USER user IDENTIFIED BY PAssWord; more example: ALTER USER user IDENTIFIED BY password ; |
|
CREATE ROLE role IDENTIFIED BY password;
SET ROLE role [IDENTIFIED BY password][,…]
ALTER ROLE role IDENTIFIED BY password;
ALTER ROLE role NOT IDENTIFIED;
DROP ROLE role;
Reader's Comments
Leave a Reply
See more website here...
Subpages
- صداقت دل
- Comedian World
- Wissenschaft
- Politik
- Songs & Videos
- Web Development projects
- Linux
Categories
- Ali Esteki (1)
- Blog (22)
- Electronic (12)
- iribTv (4)
- Linux (10)
- Ring Clock Project (4)
- Root (15)
- Tools (6)
- WordPress (6)
- اصفهان (چهارسوق) (2)
I like you FORGANI website format, when I was searching for the list of SQL*Plus privileges. It was easy to read.