set session authorization

Posted in 2005

sshumilov@gmail.com — 14 Jul 2005 09:21:06 -0700 — source: Usenet: comp.databases.informix

hello everyone! just wanted to find out one thing ... :-) when you do set session authorization... where do all the rights stay??? in what tables or views??? it should be somewhere ...

↪ replying to sshumilov@gmail.com

Art S. Kagel — Fri, 15 Jul 2005 12:23:01 -0400 — source: Usenet: comp.databases.informix

sshumilov@gmail.com wrote: > hello everyone! > > just wanted to find out one thing ... :-) > > when you do set session authorization... where do all the rights stay??? > in what tables or views??? it should be somewhere ... set session authorization; does not create any new permissions. It simply changes a DBA privileged user's identity to gain access to a table(s) utilizing the specified user's privs. IB it's all done in memory not on disk in any table since the privs expire when the current session ends. Art S. Kagel