Subject | user connect privileges |
---|---|
Author | cbasso.intercom |
Post date | 2007-12-21T12:43:26Z |
Hi,
I need to limit database connection to a single user (excluding SYSDBA)
I've created 2 users with gsec (ex. user1 and user2).
I've created a database with "create database mydb user user1 password
mypass"
If I try to connect mydb with user2, I can do it, I can see all my
table s (SHOW TABLES), I can see table structure (SHOW TABLE XXX).
I don't want to permit to another user to connect to my database.
How can I do this? I've searched for privileges, but I've found only
SELECT, INSERT, UPDATE, DELETE...
Thanks
Basso Claudio
I need to limit database connection to a single user (excluding SYSDBA)
I've created 2 users with gsec (ex. user1 and user2).
I've created a database with "create database mydb user user1 password
mypass"
If I try to connect mydb with user2, I can do it, I can see all my
table s (SHOW TABLES), I can see table structure (SHOW TABLE XXX).
I don't want to permit to another user to connect to my database.
How can I do this? I've searched for privileges, but I've found only
SELECT, INSERT, UPDATE, DELETE...
Thanks
Basso Claudio