Re: Is the owner of a table the schema?

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

Can't you login to each user and issue a select * from user_objects and see? I would say User_2.

> B) Who gives out rights on the table?

If user_1 has "grant any privilege" he could grant object privileges for any user's objects. Otherwise, in most cases, the owner grants privileges of his objects to other users. Other users may, in turn, grant these privileges to others, if they have been granted the privilege "with grant option"

> C) Is a schema always a username?

yes. Received on Thu Sep 07 2000 - 14:32:23 CDT