Script to Show System and Object Privs for a User (Doc ID 1019508.6)
Script to Show System and Object Privs for a User (Doc ID 1019508.6)
| Abstract | |
|---|---|
| Report SYSTEM and OBJECT privileges for a certain user. | |
|
Product Name, Product Version |
Oracle Server Enterprise Edition
|
| Platform | Generic |
| Date Created | 29-OCT-2002 |
| Instructions | |
Use sqlplus, connect AS SYSDBA. PROOFREAD THIS SCRIPT BEFORE USING IT! Due to differences in the way text editors, e-mail packages, and operating systems handle text formatting (spaces, tabs, and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected. |
|
| Description | |
The following scripts address the system privileges a certain user has been granted and what object privileges a user has granted or received. Note: This article contains 2 scripts. | |
| References | |
Oracle? Database Security Guide 11g Release 2 (11.2) Part Number E16543-02 |
|
| Script | |
SET ECHO off
REM NAME: TFSSYPRV.SQL
REM USAGE:"@path/tfssyprv"
REM --------------------------------------------------------------------------
REM REQUIREMENTS:
REM SELECT ANY TABLE
REM --------------------------------------------------------------------------
REM AUTHOR:
REM Geert De Paep
REM --------------------------------------------------------------------------
REM PURPOSE:
REM Show the SYSTEM privileges a certain user has.
REM ---------------------------------------------------------------------------
REM EXAMPLE:
REM SYSTEM PRIVILEGES
REM MARTY
REM CONNECT ALTER SESSION
REM CREATE CLUSTER
REM CREATE DATABASE LINK
REM CREATE SEQUENCE
REM CREATE SESSION
REM CREATE SYNONYM
REM CREATE TABLE
REM CREATE VIEW
REM
REM CONNECT (version 10gR2) CREATE SESSION
REM MARTY
REM DBA
REM EXP_FULL_DATABASE Role of 2 privs
REM DBA
REM IMP_FULL_DATABASE Role of 35 privs
REM DBA DBA-role (+- 80 privs)
REM
REM ---------------------------------------------------------------------------
REM DISCLAIMER:
REM This script is provided for educational purposes only. It is NOT
REM supported by Oracle World Wide Technical Support.
REM The script has been tested and appears to work as intended.
REM You should always run new scripts on a test instance initially.
REM --------------------------------------------------------------------------
REM Main text of script follows:
set verify off
set head off
set feedback off
set pages 20
undef naam
accept naam char prompt 'Enter username to show SYSTEM privileges of: '
set termout off
drop table testpriv;
-- DBA_ROLE_PRIV indicates which role is granted to which user
create table testpriv (grantee varchar2(30),
granted_role varchar2(32),
ptype varchar2(1));
insert into testpriv (
select grantee,granted_role,'R'
from sys.dba_role_privs);
-- DBA_SYS_PRIV indicates which privilege is granted to which user
-- directly (without using roles).
insert into testpriv
select distinct grantee,
decode(grantee, 'DBA', 'DBA-role (+- 80 privs)',
'IMP_FULL_DATABASE','Role of 35 privs',
'EXP_FULL_DATABASE','Role of 2 privs',
privilege),
'P'
from sys.dba_sys_privs
--where grantee != 'DBA'
;
set termout on
-- testpriv now contains:
-- (user, role)
-- (role, privs)
-- (user, privs)
-- So display it in a connect by format:
col title format a30 heading "System privileges" trunc
prompt SYSTEM PRIVILEGES
break on title
select lpad(grantee,length(grantee)+level*3) title,
decode (ptype,'R',null,'P',granted_role)
from testpriv
connect by grantee = prior granted_role
start with grantee = upper('&naam')
/
-- END TFSSYPRV.SQL
SET ECHO off
REM NAME: TFSOBPRV.SQL
REM USAGE:"@path/tfsobprv"
REM --------------------------------------------------------------------------
REM REQUIREMENTS:
REM SELECT ANY TABLE
REM --------------------------------------------------------------------------
REM AUTHOR:
REM Geert De Paep
REM --------------------------------------------------------------------------
REM PURPOSE:
REM Will report what OBJECT privileges are related to a certain user
REM (for GRANTOR as well as GRANTEE)
REM ---------------------------------------------------------------------------
REM EXAMPLE:
REM Enter user to evaluate: sys
REM
REM Table privileges GIVEN:
REM ======================
REM SELECT ON SYS.ACCESSIBLE_TABLES TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_ARGUMENTS TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_CATALOG TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_CLUSTERS TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_CLUSTER_HASH_E TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_COL_COMMENTS TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_COL_GRANTS_MAD TO PUBLIC
REM
REM Table privileges RECEIVED:
REM ==========================
REM SELECT ON SYSTEM.DEF$_CALL FROM SYSTEM +GRANT OPT
REM SELECT ON SYSTEM.DEF$_ERROR FROM SYSTEM +GRANT OPT
REM SELECT ON SYSTEM.DEF$_DESTINATIO FROM SYSTEM +GRANT OPT
REM SELECTON SYSTEM.DEF$_CALLDEST FROM SYSTEM +GRANT OPT
REM SELECT ON SYSTEM.REPCAT$_REPSCHE FROM SYSTEM +GRANT OPT
REM
REM Column privileges GIVEN:
REM ========================
REM
REM Column privileges RECEIVED:
REM ===========================
REM
REM ---------------------------------------------------------------------------
REM DISCLAIMER:
REM This script is provided for educational purposes only. It is NOT
REM supported by Oracle World Wide Technical Support.
REM The script has been tested and appears to work as intended.
REM You should always run new scripts on a test instance initially.
REM --------------------------------------------------------------------------
REM Main text of script follows:
set head off
set verify off
set feed off
set pause off
col pr format a10
col tn format a22
col tn2 format a30
col gr format a20
accept person char prompt 'Enter user to evaluate: '
ho clear
prompt Table privileges GIVEN:
prompt ======================
select privilege pr,
'ON',
owner||'.'||table_name tn,
'TO',
grantee gr,
decode(grantable,'YES','+GRANT OPT')
from sys.dba_tab_privs
where owner = upper('&person');
prompt
prompt Table privileges RECEIVED:
prompt ==========================
select privilege pr,
'ON',
owner||'.'||table_name tn,
'FROM',
grantor gr,
decode(grantable,'YES','+GRANT OPT')
from sys.dba_tab_privs
where grantee = upper('&person');
prompt
prompt
prompt Column privileges GIVEN:
prompt ========================
select privilege pr,
'ON',
owner||'.'||table_name||'('||column_name||')' tn2,
'-->',
grantee gr,
decode(grantable,'YES','+GRANT OPT')
from sys.dba_col_privs
where owner = upper('&person');
prompt
prompt Column privileges RECEIVED:
prompt ===========================
select privilege pr,
'ON',
owner||'.'||table_name||'('||column_name||')' tn2,
'FROM',
grantor gr,
decode(grantable,'YES','+GRANT OPT')
from sys.dba_col_privs
where grantee = upper('&person');
set head on
set verify on
set feed on
-- TFSOBPRV.SQL
|
|
| Sample Output | |
SQL9i> @tftssyprv
Enter username to show SYSTEM privileges of: ORDSYS
SYSTEM PRIVILEGES
Database Tablespace Usage Summary
ORDSYS
CONNECT ALTER SESSION
CREATE CLUSTER
CREATE DATABASE LINK
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE VIEW
ORDSYS
RESOURCE CREATE CLUSTER
CREATE INDEXTYPE
CREATE OPERATOR
CREATE PROCEDURE
CREATE SEQUENCE
CREATE TABLE
CREATE TRIGGER
Database Tablespace Usage Summary
RESOURCE CREATE TYPE
ORDSYS
JAVASYSPRIV
ORDSYS
CREATE ANY INDEXTYPE
CREATE ANY OPERATOR
CREATE ANY TABLE
CREATE ANY TYPE
CREATE LIBRARY
CREATE PROCEDURE
CREATE PUBLIC SYNONYM
CREATE SESSION
DROP ANY INDEXTYPE
DROP ANY OPERATOR
DROP ANY TYPE
DROP PUBLIC SYNONYM
UNLIMITED TABLESPACE
SQL10gR2> @tftssyprv
Enter username to show SYSTEM privileges of: TEST
SYSTEM PRIVILEGES
TEST
CONNECT CREATE SESSION
SQL> @tfsobprv
Enter user to evaluate: ORDSYS
Table privileges GIVEN:
======================
Database Tablespace Usage Summary
EXECUTE ON ORDSYS./1025308f_SunTi TO PUBLIC
leScheduler
EXECUTE ON ORDSYS./1106a6c1_Multi TO PUBLIC
plyOpImage
(output truncated)
Table privileges RECEIVED:
==========================
Database Tablespace Usage Summary
INSERT ON SYS.EXPPKGOBJ$ FROM SYS
DELETE ON SYS.EXPPKGOBJ$ FROM SYS
INSERT ON SYS.EXPPKGACT$ FROM SYS
DELETE ON SYS.EXPPKGACT$ FROM SYS
INSERT ON SYS.EXPDEPOBJ$ FROM SYS
DELETE ON SYS.EXPDEPOBJ$ FROM SYS
INSERT ON SYS.EXPDEPACT$ FROM SYS
DELETE ON SYS.EXPDEPACT$ FROM SYS
SELECT ON SYS.DBA_TABLES FROM SYS +GRANT OPT
SELECT ON SYS.DBA_OBJECT_TABLES FROM SYS +GRANT OPT
SELECT ON SYS.DBA_VIEWS FROM SYS +GRANT OPT
READ ON SYS.PICTURES FROM INTERMEDIA
Column privileges GIVEN:
========================
Column privileges RECEIVED:
===========================
|
|
| Disclaimer | |
EXCEPT WHERE EXPRESSLY PROVIDED OTHERWISE, THE INFORMATION, SOFTWARE, PROVIDED ON AN "AS IS" AND "AS AVAILABLE" BASIS. ORACLE EXPRESSLY DISCLAIMS ALL WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. ORACLE MAKES NO WARRANTY THAT: (A) THE RESULTS THAT MAY BE OBTAINED FROM THE USE OF THE SOFTWARE WILL BE ACCURATE OR RELIABLE; OR (B) THE INFORMATION, OR OTHER MATERIAL OBTAINED WILL MEET YOUR EXPECTATIONS. ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE DOWNLOADED OR OTHERWISE OBTAINED IS DONE AT YOUR OWN DISCRETION AND RISK. ORACLE SHALL HAVE NO RESPONSIBILITY FOR ANY DAMAGE TO YOUR COMPUTER SYSTEM OR LOSS OF DATA THAT RESULTS FROM THE DOWNLOAD OF ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE. ORACLE RESERVES THE RIGHT TO MAKE CHANGES OR UPDATES TO THE SOFTWARE AT ANY TIME WITHOUT NOTICE. |
|
| Limitation of Liability | |
IN NO EVENT SHALL ORACLE BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES, OR DAMAGES FOR LOSS OF PROFITS, REVENUE, DATA OR USE, INCURRED BY YOU OR ANY THIRD PARTY, WHETHER IN AN ACTION IN CONTRACT OR TORT, ARISING FROM YOUR ACCESS TO, OR USE OF, THE SOFTWARE. SOME JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY. ACCORDINGLY, SOME OF THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU. |
|
| Abstract | |
|---|---|
| Report SYSTEM and OBJECT privileges for a certain user. | |
|
Product Name, Product Version |
Oracle Server Enterprise Edition
|
| Platform | Generic |
| Date Created | 29-OCT-2002 |
| Instructions | |
Use sqlplus, connect AS SYSDBA. PROOFREAD THIS SCRIPT BEFORE USING IT! Due to differences in the way text editors, e-mail packages, and operating systems handle text formatting (spaces, tabs, and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected. |
|
| Description | |
The following scripts address the system privileges a certain user has been granted and what object privileges a user has granted or received. Note: This article contains 2 scripts. | |
| References | |
Oracle? Database Security Guide 11g Release 2 (11.2) Part Number E16543-02 |
|
| Script | |
SET ECHO off
REM NAME: TFSSYPRV.SQL
REM USAGE:"@path/tfssyprv"
REM --------------------------------------------------------------------------
REM REQUIREMENTS:
REM SELECT ANY TABLE
REM --------------------------------------------------------------------------
REM AUTHOR:
REM Geert De Paep
REM --------------------------------------------------------------------------
REM PURPOSE:
REM Show the SYSTEM privileges a certain user has.
REM ---------------------------------------------------------------------------
REM EXAMPLE:
REM SYSTEM PRIVILEGES
REM MARTY
REM CONNECT ALTER SESSION
REM CREATE CLUSTER
REM CREATE DATABASE LINK
REM CREATE SEQUENCE
REM CREATE SESSION
REM CREATE SYNONYM
REM CREATE TABLE
REM CREATE VIEW
REM
REM CONNECT (version 10gR2) CREATE SESSION
REM MARTY
REM DBA
REM EXP_FULL_DATABASE Role of 2 privs
REM DBA
REM IMP_FULL_DATABASE Role of 35 privs
REM DBA DBA-role (+- 80 privs)
REM
REM ---------------------------------------------------------------------------
REM DISCLAIMER:
REM This script is provided for educational purposes only. It is NOT
REM supported by Oracle World Wide Technical Support.
REM The script has been tested and appears to work as intended.
REM You should always run new scripts on a test instance initially.
REM --------------------------------------------------------------------------
REM Main text of script follows:
set verify off
set head off
set feedback off
set pages 20
undef naam
accept naam char prompt 'Enter username to show SYSTEM privileges of: '
set termout off
drop table testpriv;
-- DBA_ROLE_PRIV indicates which role is granted to which user
create table testpriv (grantee varchar2(30),
granted_role varchar2(32),
ptype varchar2(1));
insert into testpriv (
select grantee,granted_role,'R'
from sys.dba_role_privs);
-- DBA_SYS_PRIV indicates which privilege is granted to which user
-- directly (without using roles).
insert into testpriv
select distinct grantee,
decode(grantee, 'DBA', 'DBA-role (+- 80 privs)',
'IMP_FULL_DATABASE','Role of 35 privs',
'EXP_FULL_DATABASE','Role of 2 privs',
privilege),
'P'
from sys.dba_sys_privs
--where grantee != 'DBA'
;
set termout on
-- testpriv now contains:
-- (user, role)
-- (role, privs)
-- (user, privs)
-- So display it in a connect by format:
col title format a30 heading "System privileges" trunc
prompt SYSTEM PRIVILEGES
break on title
select lpad(grantee,length(grantee)+level*3) title,
decode (ptype,'R',null,'P',granted_role)
from testpriv
connect by grantee = prior granted_role
start with grantee = upper('&naam')
/
-- END TFSSYPRV.SQL
SET ECHO off
REM NAME: TFSOBPRV.SQL
REM USAGE:"@path/tfsobprv"
REM --------------------------------------------------------------------------
REM REQUIREMENTS:
REM SELECT ANY TABLE
REM --------------------------------------------------------------------------
REM AUTHOR:
REM Geert De Paep
REM --------------------------------------------------------------------------
REM PURPOSE:
REM Will report what OBJECT privileges are related to a certain user
REM (for GRANTOR as well as GRANTEE)
REM ---------------------------------------------------------------------------
REM EXAMPLE:
REM Enter user to evaluate: sys
REM
REM Table privileges GIVEN:
REM ======================
REM SELECT ON SYS.ACCESSIBLE_TABLES TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_ARGUMENTS TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_CATALOG TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_CLUSTERS TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_CLUSTER_HASH_E TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_COL_COMMENTS TO PUBLIC +GRANT OPT
REM SELECT ON SYS.ALL_COL_GRANTS_MAD TO PUBLIC
REM
REM Table privileges RECEIVED:
REM ==========================
REM SELECT ON SYSTEM.DEF$_CALL FROM SYSTEM +GRANT OPT
REM SELECT ON SYSTEM.DEF$_ERROR FROM SYSTEM +GRANT OPT
REM SELECT ON SYSTEM.DEF$_DESTINATIO FROM SYSTEM +GRANT OPT
REM SELECTON SYSTEM.DEF$_CALLDEST FROM SYSTEM +GRANT OPT
REM SELECT ON SYSTEM.REPCAT$_REPSCHE FROM SYSTEM +GRANT OPT
REM
REM Column privileges GIVEN:
REM ========================
REM
REM Column privileges RECEIVED:
REM ===========================
REM
REM ---------------------------------------------------------------------------
REM DISCLAIMER:
REM This script is provided for educational purposes only. It is NOT
REM supported by Oracle World Wide Technical Support.
REM The script has been tested and appears to work as intended.
REM You should always run new scripts on a test instance initially.
REM --------------------------------------------------------------------------
REM Main text of script follows:
set head off
set verify off
set feed off
set pause off
col pr format a10
col tn format a22
col tn2 format a30
col gr format a20
accept person char prompt 'Enter user to evaluate: '
ho clear
prompt Table privileges GIVEN:
prompt ======================
select privilege pr,
'ON',
owner||'.'||table_name tn,
'TO',
grantee gr,
decode(grantable,'YES','+GRANT OPT')
from sys.dba_tab_privs
where owner = upper('&person');
prompt
prompt Table privileges RECEIVED:
prompt ==========================
select privilege pr,
'ON',
owner||'.'||table_name tn,
'FROM',
grantor gr,
decode(grantable,'YES','+GRANT OPT')
from sys.dba_tab_privs
where grantee = upper('&person');
prompt
prompt
prompt Column privileges GIVEN:
prompt ========================
select privilege pr,
'ON',
owner||'.'||table_name||'('||column_name||')' tn2,
'-->',
grantee gr,
decode(grantable,'YES','+GRANT OPT')
from sys.dba_col_privs
where owner = upper('&person');
prompt
prompt Column privileges RECEIVED:
prompt ===========================
select privilege pr,
'ON',
owner||'.'||table_name||'('||column_name||')' tn2,
'FROM',
grantor gr,
decode(grantable,'YES','+GRANT OPT')
from sys.dba_col_privs
where grantee = upper('&person');
set head on
set verify on
set feed on
-- TFSOBPRV.SQL
|
|
| Sample Output | |
SQL9i> @tftssyprv
Enter username to show SYSTEM privileges of: ORDSYS
SYSTEM PRIVILEGES
Database Tablespace Usage Summary
ORDSYS
CONNECT ALTER SESSION
CREATE CLUSTER
CREATE DATABASE LINK
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE VIEW
ORDSYS
RESOURCE CREATE CLUSTER
CREATE INDEXTYPE
CREATE OPERATOR
CREATE PROCEDURE
CREATE SEQUENCE
CREATE TABLE
CREATE TRIGGER
Database Tablespace Usage Summary
RESOURCE CREATE TYPE
ORDSYS
JAVASYSPRIV
ORDSYS
CREATE ANY INDEXTYPE
CREATE ANY OPERATOR
CREATE ANY TABLE
CREATE ANY TYPE
CREATE LIBRARY
CREATE PROCEDURE
CREATE PUBLIC SYNONYM
CREATE SESSION
DROP ANY INDEXTYPE
DROP ANY OPERATOR
DROP ANY TYPE
DROP PUBLIC SYNONYM
UNLIMITED TABLESPACE
SQL10gR2> @tftssyprv
Enter username to show SYSTEM privileges of: TEST
SYSTEM PRIVILEGES
TEST
CONNECT CREATE SESSION
SQL> @tfsobprv
Enter user to evaluate: ORDSYS
Table privileges GIVEN:
======================
Database Tablespace Usage Summary
EXECUTE ON ORDSYS./1025308f_SunTi TO PUBLIC
leScheduler
EXECUTE ON ORDSYS./1106a6c1_Multi TO PUBLIC
plyOpImage
(output truncated)
Table privileges RECEIVED:
==========================
Database Tablespace Usage Summary
INSERT ON SYS.EXPPKGOBJ$ FROM SYS
DELETE ON SYS.EXPPKGOBJ$ FROM SYS
INSERT ON SYS.EXPPKGACT$ FROM SYS
DELETE ON SYS.EXPPKGACT$ FROM SYS
INSERT ON SYS.EXPDEPOBJ$ FROM SYS
DELETE ON SYS.EXPDEPOBJ$ FROM SYS
INSERT ON SYS.EXPDEPACT$ FROM SYS
DELETE ON SYS.EXPDEPACT$ FROM SYS
SELECT ON SYS.DBA_TABLES FROM SYS +GRANT OPT
SELECT ON SYS.DBA_OBJECT_TABLES FROM SYS +GRANT OPT
SELECT ON SYS.DBA_VIEWS FROM SYS +GRANT OPT
READ ON SYS.PICTURES FROM INTERMEDIA
Column privileges GIVEN:
========================
Column privileges RECEIVED:
===========================
|
|
| Disclaimer | |
EXCEPT WHERE EXPRESSLY PROVIDED OTHERWISE, THE INFORMATION, SOFTWARE, PROVIDED ON AN "AS IS" AND "AS AVAILABLE" BASIS. ORACLE EXPRESSLY DISCLAIMS ALL WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. ORACLE MAKES NO WARRANTY THAT: (A) THE RESULTS THAT MAY BE OBTAINED FROM THE USE OF THE SOFTWARE WILL BE ACCURATE OR RELIABLE; OR (B) THE INFORMATION, OR OTHER MATERIAL OBTAINED WILL MEET YOUR EXPECTATIONS. ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE DOWNLOADED OR OTHERWISE OBTAINED IS DONE AT YOUR OWN DISCRETION AND RISK. ORACLE SHALL HAVE NO RESPONSIBILITY FOR ANY DAMAGE TO YOUR COMPUTER SYSTEM OR LOSS OF DATA THAT RESULTS FROM THE DOWNLOAD OF ANY CONTENT, MATERIALS, INFORMATION OR SOFTWARE. ORACLE RESERVES THE RIGHT TO MAKE CHANGES OR UPDATES TO THE SOFTWARE AT ANY TIME WITHOUT NOTICE. |
|
| Limitation of Liability | |
IN NO EVENT SHALL ORACLE BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL OR CONSEQUENTIAL DAMAGES, OR DAMAGES FOR LOSS OF PROFITS, REVENUE, DATA OR USE, INCURRED BY YOU OR ANY THIRD PARTY, WHETHER IN AN ACTION IN CONTRACT OR TORT, ARISING FROM YOUR ACCESS TO, OR USE OF, THE SOFTWARE. SOME JURISDICTIONS DO NOT ALLOW THE LIMITATION OR EXCLUSION OF LIABILITY. ACCORDINGLY, SOME OF THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU. |
|
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1136149/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- SCRIPT: Script to Generate object privilege GRANTS (Doc ID 1020176.6)Object
- Script to Show Audit Options/Audit Trail (Doc ID 1019552.6)AI
- [Oracle Script] check object count by userOracleObject
- oracle user privsOracle
- HANGFG User Guide (Doc ID 362094.1)GUIIDE
- Script: Script to Simplify the Use of Explain Plan (Doc ID 1019631.6)AI
- RMAN Backup Shell Script Example (Doc ID 137181.1)
- [Oracle Script] check userOracle
- Script: To remove Chained Rows from a Table (Doc ID 1019556.6)REMAI
- Script to Collect DRM Information (drmdiag.sql) (Doc ID 1492990.1)ORMSQL
- Script: To list Foreign Key Constraints (Doc ID 1039297.6)AI
- Script to Report Extents and Contiguous Free Space (Doc ID 162994.1)
- 檢視某個使用者在某個物件的許可權，可以查dba_tab_privs 或者user_tab_privs物件
- Difference of Revoke System Privileges and Object PrivilegesObject
- 找不到system.web.script解決Web
- PostgreSQL DBA(148) - pgAdmin（Show script for psql command）SQL
- OBJECT_ID和DATA_OBJECT_IDObject
- Differences between DATA_OBJECT_ID and OBJECT_IDObject
- object_id 及 data_object_id (oracle)ObjectOracle
- 修改vip (Doc ID 276434.1)
- show()方法和hide()方法IDE
- IDC Script實戰
- object_id and data_object_id in dba_objectsObject
- monitor sys and system user(轉自http://www.oracle.com)HTTPOracle
- object_id 與data_object_id 的區別Object
- object_id與data_object_id淺析（一）Object
- object_id與data_object_id淺析（二）Object
- object_id與data_object_id的關係Object
- Hide the User MenuIDE
- OBJECT_ID、DATA_OBJECT_ID與truncate的本質Object
- How to Prepare Storage for ASM (Doc ID 452924.1)ASM
- [絕對原創] SAP Get User data by User ID
- Oracle中object_id和data_object_id的區別OracleObject
- Forgot Password for user id SAP*Go
- DBMS_REPAIR SCRIPT [ID 556733.1]AI
- Oracle identifiers ：SID (System Identifier)OracleIDE
- MyBatis-maven-User例子-根據id查詢UserMyBatisMaven
- data_object_id 及 object_id 的聯絡與區別Object