DB2

DB2 is IBM's offering to the highend database market. The latest version of DB2 (Universal Database) is ideal for OLTP, Data Warehousing, Decision Support and everything in between. It's well priced, extremely scalable and runs on virtually every platform out there from handhelds to mainframes.

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.

Related Links

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
Select
DB2 Federation
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

Categories

DataBase Dev
MongoDB
Adabas
DB2
Informix
Microsoft SQL Server
MySQL
Oracle
Pervasive.SQL
PostgreSQL
Sybase
Other
ASP
Crystal Reports
Delphi, C etc
JAVA
Perl and the DBI
PHP
ANSI SQL
Unix Shell Scripts
Visual Basic
Brilliant Database
Corel Paradox
FileMaker
Microsoft Access
Microsoft Excel
Other PC Databases
New Members & Introduc...
Applications & Tools
Database Concepts & De...
Chit Chat
Marketplace
Job Opportunities
Suggestions & Feedback

Resources

Mobile Apps Dev
Database Users
javascript
java
csharp
php
android
MS Developer
developer works
python
ios
c
html
jquery
RDBMS discuss
Cloud Virtualization
Database Dev&Adm
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App