Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create user with global rights ..?

Re: create user with global rights ..?

From: Md Irfan <irfan_pk_at_hotmail.com>
Date: 9 Aug 2002 07:09:53 -0700
Message-ID: <c42168e7.0208090609.53f99e2b@posting.google.com>


"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<air0m6$s60$1_at_lust.ihug.co.nz>...

Thanks for the info about 'o7_dictionary_accessibility.

> As for changing the global name, you could try the same thing. Search for
> global_name, author Howard J. Rogers, group this one, and you'll get this as
> the first thread:
>
> alter database rename global_name to NEW.NAME.AND.DOMAIN

I did a 'o7_dictionary_accessibility=true in init.ora file

and

alter global_name set global_name='NEWNAME.DOMAIN'

It worked and works fine. But what is the difference between your command syntax and the above one.

Thanks. Received on Fri Aug 09 2002 - 09:09:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US