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]
