Who am I? - Revision history

Connor: Created page with "Who am I - what is my user id?

schema:gisq

Find the user name or user id. The SQL standard permits the function USER 2012-07-17T13:46:52Z Created page with "Who am I - what is my user id? <div class='ht'> <div class=params>schema:gisq</div> <div> Find the user name or user id. The SQL standard permits the function <code>USER</code..." New page Who am I - what is my user id? <div class='ht'> <div class=params>schema:gisq</div> <div> Find the user name or user id. The SQL standard permits the function <code>USER</code> </div> <source lang=sql class='tidy'> </source> <source lang=sql class='setup'></source> <source lang='sql' class='def e-sqlite'>SELECT user FROM anyoldtable</source> <source lang='sql' class='def e-db2'>SELECT user FROM anyoldtable</source> <source lang='sql' class='def e-ingres'>SELECT user FROM anyoldtable</source> <source lang='sql' class='def e-access'>SELECT user FROM anyoldtable</source> <source lang='sql' class='def e-postgres'>select user</source> <source lang='sql' class='def e-oracle'>SELECT user, uid FROM dual</source> <source lang='sql' class='def e-sqlserver'>USE scott; SELECT user, user_id(); USE gisq; SELECT user, user_id() </source> <source lang='sql' class='def e-mysql'>SELECT user()</source> <source lang='sql' class='def e-mimer'>SELECT user FROM anyoldtable</source> <source lang='sql' class='def e-sybase'>USE scott; SELECT user, user_id(); USE gisq; SELECT user, user_id()</source> <div class="ecomm e-oracle" style="display: none">The functions are <code>user</code> and <code>uid</code></div> <div class="ecomm e-sqlserver" style="display: none">When you are in a database that you own the answer is dbo (database owner). If you USE someone else's database then you get a user id. (the machine being used to connect to MySQL).</div> <div class="ecomm e-mysql" style="display: none">The user() function include the user name and the name of the machine you are using. In this case the perl script feeding the result page is on the same machine as the database so we get <code>localhost</code>.</div> <div class="ecomm e-sybase" style="display: none">When you are in a database that you own the answer is dbo (database owner). If you <code>USE</code> someone else's database then you get a user id. (the machine being used to connect to MySQL).</div> </div> {{Users ref}}