Problem with privileges
Hello every one. I've created a table into my local DB2 database using CLI (create table MyTable). DB2 has associated the user ALFA (user of my pc) to this table and has given him all the administration privileges. But i want to access this database with another user, called DB2ADMIN. This user has not privileges on this table. I have tried to enter the DB2 control center and set manually privileges to DB2ADMIN, but into the control center i appear as SYSTEM, and i have no privileges for doing this operation. how can i do? Is it possible to switch from system to ALFA into the control center? Alternatively, is it possibile to change privileges from CLI? Thank you very much
From CLI Code: db2 grant select,insert,update,delete on <tablename> to user db2admin or when connecting to the db, you can provide the user name to use for connection Code: connect to sample user db2admin HTH Sathyaram
You can add this user to sysadmin group. It will get all the rights on this database. Except the owner of db and objects.
Timestamp column and null indicators
Looking for DB2 UDB 7.1 Trial Version
Weird Problem while retrieving data via php
Migrate DB2 8.1 Tables to DB2 9.5 with partitioning
Federated Stored Procedure - parameters
Federation Server to Oracle 10g - Sequences
ADM1832E error got ????
whats SQL Error: -1131, SQLState: 38503 ???
help: A speech interface for information retrieval using .db2 file
Data loading from DB2 UDB to DB2/MVS
Regarding LOAD ...
Move DMS Container from one dir to another ?
data migration from db2 6.1 to db2 9.1
information on db2 internal functions