SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Simple Permissions Question
-
Feb 2, 2006, 09:21 #1
- Join Date
- Mar 2002
- Posts
- 608
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Simple Permissions Question
Hello,
I want to confirm that an administrator can offer users specific permissions based on *tables*. Is this possible?
For instance, let's say there is one database (masterdb) and with 10 users, 10 tables (one per user, such as user1, user2, etc)
If I want a user to be able to connect to my mysql server from *their domain* (I grant permission to those I trust, obviously) but only be able to use THEIR user/pass to affect ONLY THEIR table, is that possible? Such as:
GRANT SELECT,INSERT,UPDATE
ON masterdb.user1
TO user1@localhost
IDENTIFIED BY 'password';
-
Feb 2, 2006, 12:36 #2
- Join Date
- Feb 2004
- Location
- Tampa, FL (US)
- Posts
- 9,854
- Mentioned
- 1 Post(s)
- Tagged
- 0 Thread(s)
yes, except that you need quotes like this: 'user1'@'localhost'
-
Feb 3, 2006, 11:20 #3
- Join Date
- Mar 2002
- Posts
- 608
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Outstanding. And since we'll use the mysql server instead of localhost, I will put that in accordingly.
Thank you VERY much.
Bookmarks