Mark Forums Read

privilege on XE

Go Back

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

Reply

#1

Old

Francy

Posts: n/a

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

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

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

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

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

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

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

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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.