dbTalk Databases Forums  

privilege on XE

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss privilege on XE in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Francy
 
Posts: n/a

Default privilege on XE - 04-05-2008 , 05:37 AM






Hi,
I need to use Oracle Designer on Oracle Express and for use designer i
must create a repository for my user (with repository administrator
utility, ok?)
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!

Reply With Quote
  #2  
Old   
Francy
 
Posts: n/a

Default Re: privilege on XE - 04-05-2008 , 06:59 AM






Francy ha scritto:
Quote:
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)


Reply With Quote
  #3  
Old   
Francy
 
Posts: n/a

Default Re: privilege on XE - 04-05-2008 , 06:59 AM



Francy ha scritto:
Quote:
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)


Reply With Quote
  #4  
Old   
Francy
 
Posts: n/a

Default Re: privilege on XE - 04-05-2008 , 06:59 AM



Francy ha scritto:
Quote:
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)


Reply With Quote
  #5  
Old   
Francy
 
Posts: n/a

Default Re: privilege on XE - 04-05-2008 , 06:59 AM



Francy ha scritto:
Quote:
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)


Reply With Quote
  #6  
Old   
Francy
 
Posts: n/a

Default Re: privilege on XE - 04-05-2008 , 06:59 AM



Francy ha scritto:
Quote:
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)


Reply With Quote
  #7  
Old   
Francy
 
Posts: n/a

Default Re: privilege on XE - 04-05-2008 , 06:59 AM



Francy ha scritto:
Quote:
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)


Reply With Quote
  #8  
Old   
Francy
 
Posts: n/a

Default Re: privilege on XE - 04-05-2008 , 06:59 AM



Francy ha scritto:
Quote:
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)


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.