Re: Granting privileges to other users
At 13:40 -0700 6/3/04, Robert Frame wrote: Thank you for the reply. I apologize for not clearly demonstrating what I am trying to accomplish. No apology necessary. I know what you're trying to accomplish. My questions (which you have not answered) are designed to cause you to think about what your GRANT statement *actually* does, because that will help lead you to understand why that statement doesn't accomplish what you want. I am trying to create an easy method of adding users to my database schema by creating a few template users. Their names are SysAdmin, Manager, and Employee. The SysAdmin will need to be able to Select, Insert, Update and Delete records for all the tables. The Manager will have a narrower range of access, with Select and Update abilities on most tables (but not all), and limited Insert and Delete records. The Employee will have the least access to the tables, with no Insert or Delete capabilities and limited Select and Update privileges. My goal is that once this is setup I can give a new user access to the tables by using the level of privileges of one of the template users, rather then specifying the exact level of access on every table for each user that I add. I am looking for the SQL command to do this. Thanks, Rob Paul DuBois [EMAIL PROTECTED] wrote: At 9:15 -0700 6/2/04, Robert Frame wrote: This is probably something simple that I am just not seeing, but I would appreciate your help. As root, I have created a schema named test, along with several tables. I then created a template user named SysAdmin for test using the following syntax. GRANT SELECT, INSERT, UPDATE, DELETE ON TEST What does ON TEST mean? TO SysAdmin IDENTIFIED BY 'password' What does TO SysAdmin mean? That is, what do *you* think the effect of those clauses should be? WITH GRANT OPTION; I plan on using SysAdmin as a template for other users. How do I do this? I would expect to be able to login as SysAdmin and then create a new user using something like: GRANT ALL ON TEST TO USER1 IDENTIFIED BY Îuser1'; However I continue to get errors saying something like SysAdmin does not have access to MySQL. Do I have to do this as root? If so, what is the syntax to do so? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Granting privileges to other users
SysAdmin only has rights to the TEST database. This user will need to be able to update the mysql database tables and therefore will need access to the mysql database. -Original Message- From: Robert Frame To: [EMAIL PROTECTED] Sent: 6/2/04 11:15 AM Subject: Granting privileges to other users This is probably something simple that I am just not seeing, but I would appreciate your help. As root, I have created a schema named test, along with several tables. I then created a template user named SysAdmin for test using the following syntax. GRANT SELECT, INSERT, UPDATE, DELETE ON TEST TO SysAdmin IDENTIFIED BY 'password' WITH GRANT OPTION; I plan on using SysAdmin as a template for other users. How do I do this? I would expect to be able to login as SysAdmin and then create a new user using something like: GRANT ALL ON TEST TO USER1 IDENTIFIED BY 'user1'; However I continue to get errors saying something like SysAdmin does not have access to MySQL. Do I have to do this as root? If so, what is the syntax to do so? Thanks. - Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Granting privileges to other users
At 9:15 -0700 6/2/04, Robert Frame wrote: This is probably something simple that I am just not seeing, but I would appreciate your help. As root, I have created a schema named test, along with several tables. I then created a template user named SysAdmin for test using the following syntax. GRANT SELECT, INSERT, UPDATE, DELETE ON TEST What does ON TEST mean? TO SysAdmin IDENTIFIED BY 'password' What does TO SysAdmin mean? That is, what do *you* think the effect of those clauses should be? WITH GRANT OPTION; I plan on using SysAdmin as a template for other users. How do I do this? I would expect to be able to login as SysAdmin and then create a new user using something like: GRANT ALL ON TEST TO USER1 IDENTIFIED BY ëuser1'; However I continue to get errors saying something like SysAdmin does not have access to MySQL. Do I have to do this as root? If so, what is the syntax to do so? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]