| |||
| |||
It’s pretty obvious what the CREATE USER statement does – it allows you to create a user in the database. Most of the popular databases out there already provide some sort of graphical interface that allows you to create users without actually typing in any SQL – like phpMyAdmin – which is a PHP interface to the MySQL database. In any case, the SQL standard defines the CREATE USER statement.
Here is what the syntax of the CREATE USER statement looks like:
CREATE USER username[IDENTIFIED BY password][other options];
The Identified By clause lets you say how the database should authenticate the user. The exact syntax of the Identified by clause varies from one database to another.
Would you like to thankProgrammerInterview.com for being a helpful free resource?Then why not tell a friend about us, orsimply add a link to this page from your webpage using the HTML below.
Link to this page:
Please bookmark with social media, your votes are noticed and appreciated:
