# Database # List of User # Privilege ### **PTO\_IT** #### Role Privilege ```sql 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 ```sql 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