Databases
Separate creation of databases, users, and grants in SQL database.
Database, SQL user, and privilege grants are independent lifecycles. Creating a user does not automatically grant database access.
Create the databaseChoose a name within the account scope.
Create the SQL userSet the credential and keep it out of source code.
Assprovider consoleate database and userGrant privileges through the grants workflow.
Validate from the applicationTest the connection from the site and confirm hostname, database, user, and password.
Access errorIf the application connects to SQL database but receives access denied to the schema, verify the grant. A user with only
USAGEhas no privileges on the application database.