Hi Green & Eugene, Thanks a lot.
On Fri, 2006-03-10 at 09:57 -0500, [EMAIL PROTECTED] wrote: > Косов Евгений <[EMAIL PROTECTED]> wrote on 03/10/2006 07:53:37 AM: > > > Hm... It seems to me In MySQL there's no such thing as "database owner". > > > Or am I missing something? > > > > Mohammed Abdul Azeem пишет: > > > Hi, > > > > > > How to check for the database owner for a particular database ? The > way > > > "show procedure status" command lists the "definer" column, Is there a > > > command that shows the database owner. Similarly, what is the command > to > > > see the owner of a table in a database ? > > > > > > Thanks in advance, > > > Abdul. > > > > > > ________________________________________ > > > This email has been Scanned for Viruses! > > > www.newbreak.com > > > > > > ======================================== > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > Eugene is right. Objects within a MySQL database are not "owned" by any > one account. They are essentially all "global" objects organized into > specific databases. > > Here's the reason behind the column your found. In the CREATE STORED > PROCEDURE statement there is a clause: > > SQL SECURITY { DEFINER | INVOKER } > > That clause tells the database under whose credentials should the > statements of the SPROC be executed. It determines if the SPROC will > execute under the credentials of the user who created it or the user who > is invoking it. DEFINER is the default value if none is specified. > > More details here: > http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > ________________________________________ This email has been Scanned for Viruses! www.newbreak.com ======================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
