It it possible to allow access to all tables in a database *except* one...
What I was hoping to do was say:
GRANT ALL ON mydb.* TO [EMAIL PROTECTED] ;
REVOKE ALL ON mydb.secrettable TO [EMAIL PROTECTED] ;
-- but it doesn't work like that... I can only revoke stuff that's previously
been specifi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Disclaimer: I'm not an SQL expert so please don't laugh. ;-)
I'm trying to generate a way to find all rows from a table where the data in
column 'foo' is a duplicate of the data in another row.
I.E.:
row | foo
1 | a
2 | c
3 | b
4 | c
5 |
