Grant Statement...

[Ashuran Zara]

read in some books Grant statement can be used to limit one's access to the database as in limit his/her to do whatever to the database...
below is a simple example of the statement...

Grant select,insert,update,delete
on Medic.Patientprofile
to admin@localhost identified by "admin"

the statement above means something like:
Grant [privileges parameter]
on database_name.table_name
to username@hostname identified by "password"

im wondering where is the table of the username,host and password is stored?we need to create it ourself?
and someone please guide me through this as im totally not familiar in how to use this statement...

http://www.shadowops.net