quering current user privileges
From: Plinio Conti (NOplinio.contiSPAM_at_libero.it)
Date: 12/23/03
- Previous message: Calin: "Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 23 Dec 2003 15:52:13 GMT
My client app, after user authentication, wants to know if user (i.e. its just created connection)
has the privileges to (for example) write on table xxx.
This way I can (for example) disable a priori editing on table xxx.
Obviouly I can't give to every user the rights to read system table (DBMS tables where user privileges are saved) only to permit them to check which rights they have.
So I can't user a SELECT on system tables.
I thought I could use
Connection.getMetaData().getTablePrivileges()
but it returns empty if user can't read system tables.
Any solution?
GRANT and REVOKE are standard SQL commands to do add/remove privileges, but I didn't find any SQL command to query (already granted) privileges....
Plinio
- Previous message: Calin: "Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|