Grant SELECT through synonym [message #516583] |
Tue, 19 July 2011 07:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6e17b966bd8875b68b8e4c5ace153ee0?s=64&d=mm&r=g) |
ArcR
Messages: 4 Registered: July 2011
|
Junior Member |
|
|
Hi Mahesh,
Could you explain why the following is working,
SQL> create table test as select * from employee;
Table created.
SQL> create synonym test_sym for employee;
Synonym created.
SQL> grant select on test_sym to chandhu;
Grant succeeded.
SQL>
|
|
|
|
|
|
|
|
|
|
Re: difference between V_$ and V$ views [message #516622 is a reply to message #516619] |
Tue, 19 July 2011 12:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
recursive definition?
SQL> select text from dba_views where view_name = 'V_$LOG';
TEXT
--------------------------------------------------------------------------------
select "GROUP#","THREAD#","SEQUENCE#","BYTES","BLOCKSIZE","MEMBERS","ARCHIVED","
STATUS","FIRST_CHANGE#","FIRST_TIME","NEXT_CHANGE#","NEXT_TIME" from v$log
SQL> show user
USER is "SYS"
so what is "v$log" above?
The "V$" views are not real objects but mapped to memory structures in SGA
|
|
|
|
|
|