Hi

If I create table as instance owner as follows:

create table someuser.junk(x int)

What privileges will someuser have. I just tested that someuser cannot
drop or
alter junk table or even create a new table under schema someuser.
Just would like to know if I am missing anything.

Thanks

Is "someuser" a valid user defined to the os?

Larry Edelstein

keith wrote:

keith wrote:
By default, 'someuser' would have no privileges, as you found.
You would need to grant createin, dropin, alterin on the schema
to the user(s). If you (i.e. as SYSADM) created the table, then
you would also need to grant control on the table to 'someuser'.

Users do not automatically get control of a schemata that has
the same name as their userID.

DB2 databases automatically have the IMPLICIT_SCHEMA authority
granted to public when they are created ... this means that any
user can create any schema in the database.


Good luck,





-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----