Re: System Table

2002-06-05 Thread Victoria Reznichenko
allowing one database per NM> user. I would like to do a lookup on a system table if it exists or if it NM> doesnt I will create a table to model this. I don't know how privilege system works in SQL Server, but in the MySQL there are some grant tables: 'user', 'db&

Re: System Table

2002-06-05 Thread Steve Edberg
100 6/5/02, Niall Merrigan wrote: >Hi List > >I am just wondering is there a sysusers / systables table in mySQL (like >SQL Server). > >I am creating an multi user script whereby users will be able to create >their own db on a linux box, but I will be only allowing one databa

RE: System Table

2002-06-05 Thread Cal Evans
[mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 5:54 AM To: [EMAIL PROTECTED] Subject: System Table Hi List I am just wondering is there a sysusers / systables table in mySQL (like SQL Server). I am creating an multi user script whereby users will be able to create their own db on a

System Table

2002-06-05 Thread Niall Merrigan
Hi List I am just wondering is there a sysusers / systables table in mySQL (like SQL Server). I am creating an multi user script whereby users will be able to create their own db on a linux box, but I will be only allowing one database per user. I would like to do a lookup on a system table