Jared : Thanks. I can do this from sys/internal. When I try to grant select on the below x$k2gte g, x$ktcxb t, x$ksuse s it gives error : ORA-2030 Jared Still <jkstill@xxxxxxxxx> wrote: On Wed, 9 Mar 2005 14:35:28 -0800 (PST), A Joshi wrote: > Is there way to check if a database link is open. //www.freelists.org/archives/oracle-l/02-2005/msg00613.html -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Make Yahoo! your home page -- //www.freelists.org/webpage/oracle-l