CREATE USER equivalent of INSERT INTO
Hi,
I'm trying to use the prepared statement to handle new user creation in the database. Currently, user is created by using "CREATE USER IDENTIFIED " statement which doesn't seem working when I put it as "Create user ? Identified as ?"
So I'm wondering if there's an equivalent statement for adding new users using INSERT INTO? If so, which tables need to be updated?
If I'm wrong with whether prepared statement can be applied on user creation or my first create user statement was wrong, please correct me.
Thank you.
I'm trying to use the prepared statement to handle new user creation in the database. Currently, user is created by using "CREATE USER IDENTIFIED " statement which doesn't seem working when I put it as "Create user ? Identified as ?"
So I'm wondering if there's an equivalent statement for adding new users using INSERT INTO? If so, which tables need to be updated?
If I'm wrong with whether prepared statement can be applied on user creation or my first create user statement was wrong, please correct me.
Thank you.
0