Re: v_$xxx views

The V_$ views are the real names of what is commonly referred to as the V$ views. The V$ name is really just a synonym. For example: V_$SQL is a view owned by SYS. After the view is created, a public synonym for it is created called V$SQL. Most people access this view by selecting from V$SQL. Since V$ is just a synonym, you can't grant privileges on it. So in order to grant privileges, you must sign on as SYS and grant privileges on the underlying V_$ view.

HTH,
Brian

robertchung0909_at_my-deja.com wrote:
>
> Just for curiosity, what are those views named v_$xxx for? (such as
> v_$sql, v_$sqlarea, etc.) Thank you in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================