Dropping Users- Users and Basic Security
Before you drop a user, it is recommended that you first lock the user. Locking the user prevents others from connecting to a locked database account. This allows you to better determine whether someone is using the account before it is dropped. Here is an example of locking a user: Any user or application attempting […]Managing Privileges- Users and Basic Security
A database user must be granted privileges before the user can perform any tasks in the database. In Oracle, you assign privileges either by granting a specific privilege to a user or by granting the privilege to a role and then granting the role that contains the privilege to a user. There are different types […]Profiles- Users and Basic Security
When you create users, requirements call for strong passwords and for the passwords to adhere to a set of security rules. You may want to ensure that a certain user is not capable of consuming inordinate amounts of CPU resources. These two examples can be done in database profiles. An Oracle profile is a database […]Assigning Default Permanent and Temporary Tablespaces- Users and Basic Security
Ensuring that users have a correct default permanent tablespace and temporary tablespace helps prevent issues of inadvertently filling up the SYSTEM or SYSAUX tablespaces, which could cause the database to become unavailable as well as create performance problems. The USERS tablespace is normally the default tablespace. When maintaining a database, you should verify the default […]
Dropping Users Making Read-Only Tables Managing Default Users Marking Architectural Decisions Oracle Certification
Understanding Schemas vs. Users- Users and Basic Security
A schema is a collection of database objects (such as tables and indexes). A user is an account to connect to the database with the username and password. Users can also own objects, which then the owner is the schema of the objects. Already discussed was how there are default schemas created to own database […]
Dropping Users Making Read-Only Tables Managing Default Users Marking Architectural Decisions NVARCHAR2 and NCHAR Oracle Certification