For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
hello,
for the apex.oracle.com ,the Social sign-in google gives the error :
it works with apexea.oracle.com
regards
jm
SQL> create user us_one identified by us1; User created. SQL> grant connect, resource to us_one; Grant succeeded. SQL> create user us_two identified by us2; User created. SQL> grant connect, resource to us_two; Grant succeeded. SQL> conn us_one/us1 Connected. SQL> create table t (id number); Table created. SQL> grant select on t to us_two; Grant succeeded. SQL> conn / as sysdba Connected. SQL> grant execute on dbms_metadata to us_two; Grant succeeded. SQL> conn us_two/us2 Connected. SQL> select dbms_metadata.get_ddl('TABLE','T','US_ONE') from dual; ERROR: ORA-31603: object "T" of type TABLE not found in schema "US_ONE" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105 ORA-06512: at "SYS.DBMS_METADATA", line 2806 ORA-06512: at "SYS.DBMS_METADATA", line 4333 ORA-06512: at line 1 no rows selected SQL> conn / as sysdba Connected. SQL> grant select_catalog_role to us_two; Grant succeeded. SQL> conn us_two/us2 Connected. SQL> select dbms_metadata.get_ddl('TABLE','T','US_ONE') from dual; DBMS_METADATA.GET_DDL('TABLE','T','US_ONE') -------------------------------------------------------------------------------- CREATE TABLE "US_ONE"."T" ( "ID" NUMBER ) PCTFREE 10 PCTUSED 40 INITRA SQL>
CREATE USER TXV IDENTIFIED BY <password> DEFAULT TABLESPACE TXV TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK; -- 3 Roles for TXV GRANT RESOURCE TO TXV; GRANT CONNECT TO TXV; GRANT SELECT_CATALOG_ROLE TO TXV; ALTER USER TXV DEFAULT ROLE ALL; -- 17 System Privileges for TXV GRANT DEBUG CONNECT SESSION TO TXV; GRANT DEBUG ANY PROCEDURE TO TXV; GRANT CREATE ANY DIRECTORY TO TXV; GRANT CREATE MATERIALIZED VIEW TO TXV; GRANT CREATE SYNONYM TO TXV; GRANT CREATE VIEW TO TXV; GRANT UNLIMITED TABLESPACE TO TXV; GRANT ADMINISTER DATABASE TRIGGER TO TXV; GRANT CREATE TRIGGER TO TXV; GRANT CREATE ANY TABLE TO TXV; GRANT CREATE TABLE TO TXV; GRANT CREATE PROCEDURE TO TXV; GRANT CREATE SEQUENCE TO TXV; GRANT CREATE SESSION TO TXV; GRANT CREATE TYPE TO TXV; GRANT SELECT ANY TABLE TO TXV; GRANT ALTER TABLESPACE TO TXV; -- 2 Tablespace Quotas for TXV ALTER USER TXV QUOTA UNLIMITED ON TXV; ALTER USER TXV QUOTA UNLIMITED ON TXV_ARCHIVE; -- 42 Object Privileges for TXV GRANT DELETE, INDEX, INSERT, SELECT, UPDATE ON COMMON.ARCHIVE_TABLES TO TXV; GRANT ALTER, SELECT ON COMMON.ARC_SEQ TO TXV; GRANT ALTER, SELECT ON COMMON.CHANGE_SEQ TO TXV; GRANT ALTER, SELECT ON COMMON.ERROR_SEQ TO TXV; GRANT ALTER, SELECT ON COMMON.JOB_SEQ TO TXV; GRANT EXECUTE ON COMMON.RMAN_MANAGER TO TXV; GRANT SELECT, UPDATE ON COMMON.SETTINGS TO TXV; GRANT ALTER, SELECT ON COMMON.SQL_SEQ TO TXV; GRANT DELETE, INSERT, SELECT, UPDATE ON COMMON.T$ARCHIVE_LOGS TO TXV; GRANT DELETE, INSERT, SELECT, UPDATE ON COMMON.T$ARCHIVE_LOGS_DETAIL TO TXV; GRANT SELECT ON COMMON.T$CHANGE_LOG TO TXV; GRANT SELECT ON COMMON.T$DBA_INDEXES TO TXV; GRANT SELECT ON COMMON.T$DBA_PART_TABLES TO TXV; GRANT SELECT ON COMMON.T$DBA_TABLES TO TXV; GRANT SELECT ON COMMON.T$DBA_TAB_PARTITIONS TO TXV; GRANT SELECT ON COMMON.T$DBA_USERS TO TXV; GRANT INSERT, SELECT, UPDATE ON COMMON.T$ERRORS TO TXV; GRANT SELECT ON COMMON.T$SESSION_LOG TO TXV; GRANT DELETE, INSERT, SELECT, UPDATE ON COMMON.T$SQL_LOG TO TXV; GRANT EXECUTE ON COMMON.UTILS TO TXV; GRANT SELECT ON SYS.DBA_CONSTRAINTS TO TXV; GRANT SELECT ON SYS.DBA_DATA_FILES TO TXV; GRANT SELECT ON SYS.DBA_FREE_SPACE TO TXV; GRANT SELECT ON SYS.DBA_IND_COLUMNS TO TXV; GRANT SELECT ON SYS.DBA_INDEXES TO TXV; GRANT SELECT ON SYS.DBA_PART_TABLES TO TXV; GRANT SELECT ON SYS.DBA_TAB_COLUMNS TO TXV; GRANT SELECT ON SYS.DBA_TABLES TO TXV; GRANT SELECT ON SYS.DBA_TABLESPACES TO TXV; GRANT SELECT ON SYS.DBA_TAB_PARTITIONS TO TXV; GRANT SELECT ON SYS.DBA_USERS TO TXV; GRANT SELECT ON SYS.T$DBA_CONSTRAINTS TO TXV; GRANT EXECUTE, READ, WRITE ON DIRECTORY SYS.TPS_SAVE TO TXV WITH GRANT OPTION; GRANT SELECT ON SYS.V_$BACKUP_DATAFILE TO TXV; GRANT SELECT ON SYS.V_$DATABASE TO TXV; GRANT SELECT ON SYS.V_$DATABASE_BLOCK_CORRUPTION TO TXV; GRANT SELECT ON SYS.V_$DATAFILE TO TXV; GRANT SELECT ON SYS.V_$DATAFILE_HEADER TO TXV; GRANT SELECT ON SYS.V_$INSTANCE TO TXV; GRANT SELECT ON SYS.V_$PARAMETER TO TXV; GRANT SELECT ON SYS.V_$SESSION TO TXV; GRANT SELECT ON SYS.V_$TABLESPACE TO TXV;
I also receive no_data_found error when calling from a named procedure. I added all grants from the role SELECT_CATALOG_ROLE and its subrole HS_ADMIN_SELECT_ROLE
select 'grant ' || privilege || ' on ' || owner || '.' || table_name || ' to <schema name>;' from role_tab_privs
where role = 'SELECT_CATALOG_ROLE' or role = 'HS_ADMIN_SELECT_ROLE';
But it didn't help (I won't paste the result of this query, because it returns >2000 lines).
What else could be necessary?