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 OOPS

Re: create user and grant OOPS

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Thu, 25 Jul 2002 12:08:47 -0500
Message-ID: <stb0kucrmrc4ua11kl5sn9rjahv62riedb@4ax.com>


I should take my own advice and read the docs..

Since we never grant the
'Create ANY <whatever>' and 'select ANY' prigs ( we don't like global grants)  I tend to forget about the ability to use them...

So ignore my errors in the post regarding creating stuff in other schemas..

{downcast eyes here)

TurkBear <jgreco1_at_mn.rr.com> wrote:

>
>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 =-----

-----------== 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 - 12:08:47 CDT

Original text of this message

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