Etichetă: grant

Drepturi pe view-uri dinamice

Dacă încercați să acordați drepturi pentru un utilizator sau un rol asupra unui obiect V$views, veți obține eroare ORA-02030.

SQL> grant select on V$SESSION to myuser;
grant select on V$SESSION to myuser
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views

Acest lucru se datorează faptului că încercați să acordați drepturi pe un sinonim. Trebuie să executați grant-ul pe tabela:

SQL> select * from dba_synonyms where synonym_name='V$SESSION';

OWNER      SYNONYM_NAME    TABLE_OWNER    TABLE_NAME      DB_LINK
---------- --------------- -------------- --------------- -----------
PUBLIC     V$SESSION       SYS            V_$SESSION

SQL>grant select on V_$SESSION to myuser;
Grant succeeded.
Learning is not a spectator sport

Connor McDonald on SQL and the Oracle Database

Enmotech Blog

Specialized in Oracle Cloud Database ( DBaaS )

oradbaro

Focusing On Oracle Database Administration

Another Oracle blog

Another blog about Oracle

Mathijs Bruggink

Tips Tricks and Blogs on Oracle

Oracle Romania

Simplify IT

Programat in Romania

Blogul industriei de software din Romania. Comunitate dezvoltatori

Dan Bârsan

The miracle is not that we do this work, but that we are happy to do it. I'm writing in Romanian and English

Romanian Oracle User Group

Focusing On Oracle Database Administration

Big Lazy SysAdmin

Adapt. Enjoy. Survive.

Inovat in Romania

Blogul industriei software din Romania

Talip Hakan Ozturk's ORACLE BLOG

The secret of success is at your fingertips!...

Uwe Hesse

about Database Technology

Learning is not a spectator sport

Connor McDonald on SQL and the Oracle Database

Enmotech Blog

Specialized in Oracle Cloud Database ( DBaaS )

oradbaro

Focusing On Oracle Database Administration

Another Oracle blog

Another blog about Oracle

Mathijs Bruggink

Tips Tricks and Blogs on Oracle

Oracle Romania

Simplify IT

Programat in Romania

Blogul industriei de software din Romania. Comunitate dezvoltatori

Dan Bârsan

The miracle is not that we do this work, but that we are happy to do it. I'm writing in Romanian and English

Romanian Oracle User Group

Focusing On Oracle Database Administration

Big Lazy SysAdmin

Adapt. Enjoy. Survive.

Inovat in Romania

Blogul industriei software din Romania

Talip Hakan Ozturk's ORACLE BLOG

The secret of success is at your fingertips!...

Uwe Hesse

about Database Technology