quering current user privileges

From: Plinio Conti (NOplinio.contiSPAM_at_libero.it)
Date: 12/23/03

  • Next message: akmal chaudhri: "Java Data Objects - BCS OOPS Evening Series 2004" 
    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

  • Next message: akmal chaudhri: "Java Data Objects - BCS OOPS Evening Series 2004"

    Relevant Pages

    • RE: Upgraded to Word 2003, now I cant open files
      ... Novell NetWare Network Privileges Required to Run Word ... Description of File System Directory and File Rights ...
      (microsoft.public.word.application.errors)
    • =?windows-1252?Q?Re=3A_=93Libertarians=2C=94=2F_vs_Corporate_Power?=
      ... result is that these collectivist entities with their government- ... bestowed privileges have taken over our economy, ... the defenders of individual rights. ... distinction between Big Brother and God! ...
      (alt.gathering.rainbow)
    • Re: turn off user account control
      ... Another possibility is that the developers might not be using the least privileges that their software needs and instead required Administrator privileges. ... what is requiring admin rights to run is old legacy COM solutions. ... One of the requirements of Vista compliant software is that it only needs Standard user rights to execute. ... But the bottom line is to make the application run with only requiring Standard user rights or least privilege, which most software developers bluntly disregard and everything runs with full-admin-rights when 9 times out of 10 it is not required. ...
      (microsoft.public.windows.vista.security)
    • Re: How to manage user access in FM7 and later
      ... > profiles and then use this groups to assign rights in FMP. ... > personal login system and a users file where a rights manager could ... > Take into account that the delegated rights manager knows nothing ... about everything you can do with homebuilt, individual privileges can be ...
      (comp.databases.filemaker)
    • What is the Anglobitch Thesis?
      ... the advance of women's 'rights' across the Anglosphere has not been ... accompanied by a corresponding reduction of their traditional privileges - ... men only with obligations and women aglow with rights plus privileges. ... Anglo-American media, ...
      (soc.men)