Obtendo todas as permissões SELECT do Owner e conceder a um usuário.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
SYS@ORCL > select 'GRANT SELECT ON '|| owner ||'.' || object_name || ' TO USER;' from all_objects where owner='NOME'; GRANT SELECT ON NBS.PK_BKP_OPER_ID TO USER; GRANT SELECT ON NBS.SEQ_BKP_OPER_ID TO USER; GRANT SELECT ON NBS.BKP_TABELA TO USER; GRANT SELECT ON NBS.PK_BKP_TABELA_ID TO USER; GRANT SELECT ON NBS.SEQ_BKP_TABELA_ID TO USER; GRANT SELECT ON NBS.BKP_CAMPO_BLOB TO USER; GRANT SELECT ON NBS.PK_BKP_CAMPO_BLOB_ID TO USER; GRANT SELECT ON NBS.SEQ_BKP_CAMPO_BLOB_ID TO USER; GRANT SELECT ON NBS.BKP_MOVIMENTO TO USER; GRANT SELECT ON NBS.PK_BKP_MOV_ID TO USER; GRANT SELECT ON NBS.SEQ_BKP_MOV_ID TO USER; GRANT SELECT ON NBS.HYUNDAI_WS_LOG TO USER; GRANT SELECT ON NBS.SYS_C00101260 TO USER; GRANT SELECT ON NBS.SEQ_HYUNDAI_WS_LOG TO USER; GRANT SELECT ON NBS.IDXCONTROLE_SERIE TO USER; GRANT SELECT ON NBS.IDX_SPED_ITENS_DOCUMENTO_DATA TO USER; GRANT SELECT ON NBS.FORD_EXT_MOV_OIC TO USER; GRANT SELECT ON NBS.IDX_FORD_EXT_MOV_OIC TO USER; 13786 rows selected. |