Re: System Table

2002-06-05 Thread Victoria Reznichenko
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

Re: System Table

2002-06-05 Thread Steve Edberg
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

RE: System Table

2002-06-05 Thread Cal Evans
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