Re: privilege on XE
From: Francy <francynospam_at_dada.net>
Date: Sat, 05 Apr 2008 13:59:26 +0200
Message-ID: <9TJJj.92$hw.38_at_nntpserver.swip.net>
Date: Sat, 05 Apr 2008 13:59:26 +0200
Message-ID: <9TJJj.92$hw.38_at_nntpserver.swip.net>
Francy ha scritto:
> I can't access to repository administrator as sys or system so i need to
> create a new user to manage repository...but this user need the select
> privilege on v_$parameter...how can I create an user with this privilege?
> I'm on Oracle Express, without enterprise manager!
Ok, using SQL:
GRANT SELECT ON v_$parameter to (user_name) Received on Sat Apr 05 2008 - 13:59:26 CEST