Re: [SQL] Revoke on all database

2004-12-18 Thread Kretschmer Andreas
am Sat, dem 18.12.2004, um 12:54:33 -0500 mailte Henry Molina folgendes: > Hi all, > > Can I revoke "delete" on all database, something like this: on all databases, or on all tables in one database? > > REVOKE DELETE ON DATABASE mydb FROM PUBLIC; IMHO no, but you can walk through all database

[SQL] Revoke on all database

2004-12-18 Thread Henry Molina
Hi all, Can I revoke "delete" on all database, something like this: REVOKE DELETE ON DATABASE mydb FROM PUBLIC; thanks! -- Henry Molina R&D CMN Consulting ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index s