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]
