Difference between Database Connect and Database Access.



IBM's flagship relational database management system

Difference between Database Connect and Database Access.

Postby mainframe_amit » Sat Dec 13, 2008 10:56 am

In System Control Authority, System Maintanance Authority and System Monitor Authority, the groups have been given authority to connect to the database where as they don't have authority to access to the database.

Could you please differentiate Database connect and Database Access in this aspect.
Please let me know if I am not clear in my query.
mainframe_amit
 
Posts: 6
Joined: Wed Aug 06, 2008 11:49 am
Has thanked: 0 time
Been thanked: 0 time

Re: Difference between Database Connect and Database Access.

Postby dick scherrer » Sun Dec 14, 2008 1:48 am

Hello,

Connect authority allows one entry to the database environment.

Access authority defines the permissions the user has to operate within the enviropnment (i.e read tables, update tables, etc).

You might think of it as a building with a "front door" and many doors in the halls inside the building. "Connect" would be the key to the front door allowing entry to the building. "Access" would be the keys to open the interior doors once one had gotten thru the front door.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Difference between Database Connect and Database Access.

Postby mainframe_amit » Mon Dec 15, 2008 10:35 am

Hi,

Thanks for clarifying my doubt on this.
Could you please confirm me what are all operations can a group or user perform on that database if he has only Database Connect Authority (don't have Database access authority).

Thanks & Regards,
Amit Goel
mainframe_amit
 
Posts: 6
Joined: Wed Aug 06, 2008 11:49 am
Has thanked: 0 time
Been thanked: 0 time

Re: Difference between Database Connect and Database Access.

Postby dick scherrer » Mon Dec 15, 2008 10:41 am

Hello,

Suggest you talk with your dbs for the specifics of your environment. There are multiple ways to configure/secure an environment.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post