db2 on linux question

unika · #1 (**permalink**) 08-18-04, 18:22

i just installed the db2 on my home linux machine and cannt figure out how i can grant create database to some user other then instance owner.
i've got three db2 related users: db2admin, db2inst, db2fenc.
Now how i can create a database MYDB as a user say user1, and use sql statements like select * from table1, without explicit schema name?

Marcus_A · #2 (**permalink**) 08-18-04, 19:14

Create database is not an SQL command so it is not governed by normal grant and revoke SQL. I beleive that you need to put them in the sysadm group in the database manager parms (DBM).

unika · #3 (**permalink**) 08-19-04, 05:13

Quote:

Originally Posted by Marcus_A

Create database is not an SQL command so it is not governed by normal grant and revoke SQL. I beleive that you need to put them in the sysadm group in the database manager parms (DBM).

ok, i got it.
thanks!

Internet Services

Web Development

Digital Marketing

Consumer Tech