More details

Some details: database is "biblis" Table owner is "biblis" Main user is "bibhpx" The sample table t_orders can be updated by "alain" without having run any "set role" ____________________________________________________ tabname t_orders owner biblis partnum 2097203 tabid 120 rowsize 273 ncols 10 nindexes 2 nrows 6 created 21/09/98 version 7864329 tabtype T locklevel R npused 1 fextsize 16001 nextsize 2666 flags 0 _______________________________________________________________ >dbschema -d biblis -r odbcDBSCHEMA Schema Utility INFORMIX-SQL Version 7.23.UC7 create role "odbc" ; grant "odbc" to "alain" ; > _______________________________________________________________ >dbschema -d biblis -p alainDBSCHEMA Schema Utility INFORMIX-SQL Version 7.23.UC7 No permissions for user alain. > _______________________________________________________________ dbschema -d biblis -p odbc |grep t_ordersgrant select on "biblis".t_orders to "odbc" as "biblis";_______________________________________________________________ INFO - t_orders: Columns Indexes Privileges References Status ... Display user access privileges for a table. --------------- biblis@biblis_hpx ---- Press CTRL-W for Help -------- User Select Update Insert Delete Index Alter odbc All None No No No No bibhpx All All Yes Yes Yes Yes _____________________________________________________ >more /etc/passwd informix::100:100:Informix,,,:/opt/informix:/bin/ksh biblis::104:101:biblis,,,:/bibhpx:/bin/ksh bibhpx::101:101:biblis,,,:/bibhpx:/bin/ksh alain::103:20:Alain,,226,:/home/alain:/usr/bin/ksh