<p>On IBM DB2 v.9 windows, when someone connect to database by Server\Administrator user
DB2 database will automatically accept and grant all the permissions to this user?
But, in some case environment Administrator of server does not need to see every data in the database. So how to prevent Administrator use connect to database?</p>

By default, DB2 databases are created with
```
CONNECT
```
authority granted to public.  If you want to restrict some users from connecting, you need to do
```
```
GRANT CONNECT ON DATABASE TO <user1>, <user2>, ...
```
```
Then revoke the CONNECT authority from PUBLIC
```
```
REVOKE CONNECT ON DATABASE FROM PUBLIC
```
```