Re: create user and grant

In article <f070ku85aujp0vdub9i769kesq4v60dboo_at_4ax.com>, TurkBear says...
>
>
>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..

True until 9.2. In 9.2, DBA's can grant access to other user's objects (finally!)

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

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Thu Jul 25 2002 - 11:35:30 CDT