If you want at the database level so you can query dba_tab_privs to get that information. On Sun, Nov 23, 2008 at 4:15 AM, khabeer khayyam <khabeer1983@xxxxxxxxx>wrote: > Hi, > > Can anybody plz tell me what's d query to use to find out > the rights/privileges a user has over other schemas objects. > > Thanks, > > Khayyam > > > ------------------------------ > Add more friends to your messenger and enjoy! Invite them > now.<http://in.rd.yahoo.com/tagline_messenger_6/*http://messenger.yahoo.com/invite/> > >