Skip to main content

Privilege

PTO_IT

Role Privilege

SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'PTO_IT';
GRANTEE GRANTED_ROLE ADMIN_OPTION DELEGATE_OPTION DEFAULT_ROLE COMMON INHERITED
PTO_IT PTO_IT_ROLE NO NO YES NO NO

 

System Privilege

SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE IN ('PTO_IT','PTO_IT_ROLE');
GRANTEE PRIVILEGE ADMIN_OPTION COMMON INHERITED
PTO_IT CREATE PROCEDURE NO NO NO
PTO_IT CREATE SESSION NO NO NO
PTO_IT CREATE SEQUENCE NO NO NO
PTO_IT_ROLE CREATE ANY SEQUENCE NO NO NO
PTO_IT_ROLE ALTER ANY SEQUENCE NO NO NO
PTO_IT_ROLE SELECT ANY SEQUENCE NO NO NO

Object Privilege

 










PTO_IT SYS V_$ARCHIVED_LOG SYS SELECT NO NO NO VIEW NO
PTO_IT BIBLIOALL CUSTOMER BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT BIBLIOALL CUSTOMERADDRESS BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT BIBLIOALL CUSTOMERAGENTREGISTERED BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT BIBLIOMARK MARK BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT PROCEDURES EXCLUDEAUTOMATION PROCEDURES DELETE NO NO NO TABLE NO
PTO_IT PROCEDURES EXCLUDEAUTOMATION PROCEDURES INSERT NO NO NO TABLE NO
PTO_IT PROCEDURES EXCLUDEAUTOMATION PROCEDURES UPDATE NO NO NO TABLE NO
PTO_IT WORKFLOW PTOUSER WORKFLOW SELECT NO NO NO TABLE NO
PTO_IT MYPTOREP DMR_CONTENT_S MYPTOREP SELECT NO NO NO TABLE NO
PTO_IT MYPTOREP DMR_CONTENT_R MYPTOREP SELECT NO NO NO TABLE NO
PTO_IT MYPTOREP DMI_QUEUE_ITEM_S MYPTOREP SELECT NO NO NO TABLE NO
PTO_IT MIGRATION USERS MIGRATION SELECT NO NO NO TABLE NO
PTO_IT MIGRATION PTHISTORY MIGRATION SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOPATENT CLASSIN_CPC BIBLIOPATENT SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOPATENT CLASSIFICATION BIBLIOPATENT SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOPATENT PATENT BIBLIOPATENT SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOPATENT IPC BIBLIOPATENT SELECT NO NO NO VIEW NO
PTO_IT_ROLE BIBLIOPATENT PRIORART BIBLIOPATENT SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOPATENT PRECLASSIFICATION BIBLIOPATENT SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOPATENT CPC BIBLIOPATENT SELECT NO NO NO VIEW NO
PTO_IT_ROLE BIBLIOALL CONTRACT BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL CUSTOMER BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL CUSTOMER BIBLIOALL UPDATE NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL GENERALINFO BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL OFFICECLOSUREPERIOD BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL CUSTOMERADDRESS BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL CUSTOMERADDRESS BIBLIOALL UPDATE NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL CUSTOMERAGENTREGISTERED BIBLIOALL DELETE NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL CUSTOMERAGENTREGISTERED BIBLIOALL INSERT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL CUSTOMERAGENTREGISTERED BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL CUSTOMERAGENTREGISTERED BIBLIOALL UPDATE NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL OPPOSITION BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL PRIORITY BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL PRIORITYDOCUMENT BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL HOLIDAYS BIBLIOALL DELETE NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL HOLIDAYS BIBLIOALL INSERT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL HOLIDAYS BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL HOLIDAYS BIBLIOALL UPDATE NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL PROREQUEST BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL PROREQUEST BIBLIOALL UPDATE NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL ALLOTGRNR BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL COURTDECISION BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL ALLOTDOCNR BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL DMBATCH BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL DMBATCHDOC BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL EXTENSION BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL TMP_RANSOMWARE_RECOVERY BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOALL ALLOTDIVCHILDNR BIBLIOALL SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOGR GENERALREQUEST BIBLIOGR SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOMARK REP_CATEGPICT BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOMARK DESIGNATEDCOUNTRY BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOMARK GOODS BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOMARK MARK BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOMARK PICTURE BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOMARK PSAACSEPTOSEARCH BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOMARK TMAMENDMENT BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT_ROLE BIBLIOMARK TMSECURITYINTEREST BIBLIOMARK SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBPREASONFORAPPOINTMENT DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBADECLARATION DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS IPC_VERSION DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BIN$+TmxJNCxaQLgU8IAEKyD8g==$0 DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BIN$+TmxJNC1aQLgU8IAEKyD8g==$0 DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BIN$+TmxJNC5aQLgU8IAEKyD8g==$0 DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMHEARINGREASON DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMOBJECTION DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS CPC DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS PROTYINFORMATION DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS PUBLICATIONDOMAIN DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBASTATUSCLASSIF DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS PROPROCTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS WFACTIVITY DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS ACSEPTOQUEUESTATUS DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS PROPLAYERTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS COUNTRY DEFINITIONS DELETE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS COUNTRY DEFINITIONS INSERT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS COUNTRY DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS COUNTRY DEFINITIONS UPDATE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBADOMAIN DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBADISCUSSIONTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS REQUESTTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBACITY DEFINITIONS DELETE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBACITY DEFINITIONS INSERT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBACITY DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBACITY DEFINITIONS UPDATE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAREGION DEFINITIONS DELETE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAREGION DEFINITIONS INSERT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAREGION DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAREGION DEFINITIONS UPDATE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAEXTERNALSOURCE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS EXCLUDEDWORD DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBATYPROFILE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAIDTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAWORLD DEFINITIONS DELETE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAWORLD DEFINITIONS INSERT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAWORLD DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAWORLD DEFINITIONS UPDATE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS ELEMENT DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS CHECKLISTACTIVITY DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS HTMLCHECKLIST DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS HTMLCHECKLISTPARAGRAPH DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS CHECKLISTIMPACT DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS PARAGRAPHCONTENT DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS PROROLETYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMGOODSANDSERVICESDETAILS DEFINITIONS DELETE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMGOODSANDSERVICESDETAILS DEFINITIONS INSERT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMGOODSANDSERVICESDETAILS DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMGOODSANDSERVICESDETAILS DEFINITIONS UPDATE NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS HSTHISTORYTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS WFPROCESS DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS DMCONFIDLEVEL DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS DMDOCTYPES DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBPTECHGROUP DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMMARKTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMNATUREMARK DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS DMDOCFAMILIES DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMCHARACTERTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAPRIORITYSTATUS DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBMGOODSANDSERVICES DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS WFENTREPRISETYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBPPATENTTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBATYUSER DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBAORGUSER DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBATYCUSTOMER DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS IPC DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBPAMENDMENTREASON DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBPAMENDMENTTYPE DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBATYPAPER DEFINITIONS SELECT NO NO NO TABLE NO
PTO_IT_ROLE DEFINITIONS BBABATCHSTATUS DEFINITIONS SELECT NO NO NO TABLE NO

Table Privilege

Column Privilege