[HACKERS] Complete Database Permission

2001-03-31 Thread Johnny Cristensen
Hi Everybody:       How can i set permission for any user (in a database) in the entire database (all tables) ??? with GRANT is just one table (or list), but i want , for example, create a user and set his permissions in all tables , but just SELECT for example, (without set sup

[HACKERS] ODBC Problems

2001-03-31 Thread Johnny Cristensen
Hi EveryBody               When i connect to my database in windows98 (ODBC) to the server in Linux, i can execute SELECT staments , but no INSERT or UPDATE staments... the error 'Key Violation ..Connection is readonly , only select staments are allowed' appears. the user was created wit

[HACKERS] Permissions on All Tables

2001-03-31 Thread Johnny Cristensen
Hi EveryBody!!!       How can i set permission for any user (SELECT for example) in all tables (any database) without list all tables in GRANT stament?   Thanks!

[HACKERS] Table Structure

2001-03-31 Thread Johnny Cristensen
Hi EveryBody:       How can i get the structure of a table (Fields names, data types, etc)???     Thanks