Niall,
Wednesday, June 05, 2002, 1:53:59 PM, you wrote:
NM> I am just wondering is there a sysusers / systables table in mySQL (like
NM> SQL Server).
NM> I am creating an multi user script whereby users will be able to create
NM> their own db on a linux box, but I will be only allowing one data
Take a look at the 'mysql' database; the relevant tables are 'user' and 'ub'.
See:
http://www.mysql.com/doc/P/r/Privileges.html
And
http://www.mysql.com/doc/P/r/Privilege_system.html
http://www.mysql.com/doc/U/s/User_Account_Management.html
If your naming scheme is to nam
Not like they exist in MS SQL. However, take a look at the mysql database.
My guess is that you can infer the information you want from the permissions
granted.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Niall Merrigan