Re: Role/Privs

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Tue, 10 Jan 2006 09:38:11 -0500
Message-ID: <qdWdnQaWSopKW17eRVn-hQ@comcast.com>

"camou" <camou_at_camou> wrote in message
news:11s7h9r8vh26q11_at_news.supernews.com...
> What system privs or roles must be provided to a non-dba user to allow
> them to use the sys.user_* views that are inturn linked to sys.$* tables?
>
> Thanks

none

well, actually create session

privs are granted to PUBLIC for the USER_* views, any user connected to the database has access

++ mcs Received on Tue Jan 10 2006 - 08:38:11 CST