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 and grant

Re: create user and grant

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 26 Jul 2002 11:20:48 +1000
Message-ID: <Cm109.44023$Hj3.133924@newsfeeds.bigpond.com>


Hi TurkBear (love the name).

You *can* create objects in other schemas, that's been around for a long time. You just need the CREATE ANY (say) TABLE system privilege to do so.

It's the granting of object level privileges that's been impossible (until now) from outside the schema.

Cheers

Richard
"TurkBear" <jgreco1_at_mn.rr.com> wrote in message news:f070ku85aujp0vdub9i769kesq4v60dboo_at_4ax.com...
>
> And bear in mind that only the 'owner' of the data can GRANT access to it
,
> so for ryan to see john's tables, JOHN has to do the granting..even the
DBA can't..
> Same thing applies to creating things - they can only be created in your
own schema, so
> ryan, for instance, no matter what rights he has, cannot issue a
> 'CREATE TABLE JOHN.TABLE2' statement only John could..
>
> The docs are a great resource..Use them..
>
>
>
>
> "Tom Best" <oracle_person_at_yahoo.com> wrote:
>
> >Gabor:
> >
> >The quick answer is, by default, each user sees only the data in his
> >"schema" i.e. the tables under his username. john can have a table
called
> >"tab1" and so can bill, and they are totally separate tables. If you
want
> >to share data from a schema to another user, you GRANT access to it for
that
> >user. You may also create SYNONYMs to allow the other user to refer to
the
> >table without prefixing it with the owner's userid.
> >
> >So, yes, bill and john are different users, with different data. They
can't
> >see each others data (by default). And if you create "ryan", again, he
will
> >have access only to HIS objects. The SQL statement "GRANT" will allow
other
> >users to see his data.
> >
> >Take a look at Part VIII of this:
> >
>
>http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817
/
> >a76965/toc.htm
> >
> >HTH,
> >Tom Best
> >
> >
> >
> >"gulyas gabor" <gabor.gulyas_at_sysdata.siemens.hu> wrote in message
> >news:ahp0vu$497$1_at_news.siemens.at...
> >> Hi all,
> >>
> >> I am new to oracle, so I would like to ask a little help.
> >> I use oracle 8.1.7 on unix platform with SQLplus.
> >> There is a database called kurbie and if I use the 'sqlplus
> >> john/john_at_kurbie' command I can administrate some tables, views, etc.
> >> But if I use 'sqlplus bill/bill_at_kurbie' as command then different
tables,
> >> views, etc. are available.
> >>
> >> I think that bill and john are different users, they use the same
> >database,
> >> but they have different rights, so both of them can reach their own
> >things,
> >> and the others are unavailable for them. Is it right ?
> >>
> >> So it is the present situation, and here is my question:
> >> I would like to use this kurbie database as mentioned above, but I need
a
> >> third case to the existing two.
> >> with 'sqlplus ryan/ryan_at_kurbie' I want to see nothing from the data of
> >john
> >> and bill, but I want to create ryan's data.
> >>
> >> If you know how to do this, please answer me. (Ithink I should create a
> >new
> >> user and then grant rights, but I don't know how to do this exactly.)
> >>
> >> thanks a lot,
> >> Gabor
> >>
> >>
> >
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Thu Jul 25 2002 - 20:20:48 CDT

Original text of this message

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