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

Get diagnostics exception - error line
I need to force application one bye one as script in Solaries
S04E for COBOL/DB2 stored procedure
Is Reorg needed after table LOAD?
AUTORESIZE in DB2 V8.2
question about IDENTITY
**Error while configuring DB2 client : URGENT**
about creat a table
How to move/cleanup active log files
Advanced Merge code
problem with creation of buffer pool
Arabic char conversion from CCSID1256 to 420
SQL Stored Procedure
dBase 4
Runstats problem
Issues with EXECUTE IMMEDIATE with USING Clause and it's alternative in DB2

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