Re: Is the owner of a table the schema?

Answers embedded

Hth,

Sybrand Bakker, Oracle DBA

"Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote in message news:39b7e063.862112578_at_news.alt.net...
> 1) Two users
> a) User_1
> b) User_2
>
> 2) GRANT CREATE ANY TABLE TO User_1;
>
> 3) User_1 creates User_2.Table_1.
>
> A) Who is the table owner?
>

user_2

> B) Who gives out rights on the table?
>

user_2

> C) Is a schema always a username?

Yes
>
> Brian
>
>

Please try to read the Oracle Concepts Manual. Received on Thu Sep 07 2000 - 14:26:54 CDT