Oracle creates users, roles, grants, and tables.
Oracle is a relational database management system that enables the creation of users, roles, grants, and tables through the following steps:
- Create a user:
Log in to the database with sysdba privileges. - Log in to SQL*Plus as the system administrator using the following command: “sqlplus / as sysdba.”
- “Create user:”
- Make a new user with the given username and password.
- Authorized users:
- Give permission to username to connect, use resources, and create sessions.
- Exit the database.
- Leave;
- Create a character: Sign in to the database using the same username and password as when creating the user.
- Login to SQLPlus with the specified username and password.
- Create a character:
- Assign a role named “rolename”.
- Grant role permissions.
- Authorize the role to have permission.
- Exit the database.
- Leave;
- Authorized users:
Login to the database with sysdba privileges. - Please login to the SQL*Plus tool as the sysdba user.
- Authorized user
- Assign the role to the specified username.
- Exit the database.
- Leave;
- Create a table:
Log in to the database using the username and password created when the user was created. - Login to sqlplus using your username and password.
- Create a table:
- To make a new table called “tablename” with columns, just specify the column names, data type, and any constraints.
- Exit database
- leave;
The above steps can be adjusted and modified according to specific needs, such as specific settings for authorization and permissions.