db2 luw: Grant connect privilege on database

Below is the syntax to grant PROD user the CONNECT privilege on a database named PRODDB:

db2 => connect to PRODDB

Database Connection Information

Database server = DB2/AIX64 10.1.4
SQL authorization ID = DB2INST1
Local database alias = PRODDB

db2 => grant connect on database to user PROD
DB20000I The SQL command completed successfully.
db2 =>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: