Understanding Table Types- Tables and Constraints
The Oracle database supports a vast and robust variety of table types. These various types are described in Table 7-1. Table 7-1. Oracle Table Type Descriptions This chapter focuses on the table types that are most often used: heap organized, index organized, and temporary tables. Partitioned tables are used extensively in data warehouse environments and […]Schema Privileges- Users and Basic Security
New with 23c, you can now grant a schema to a user. This means all of the objects in the schema will be granted. This simplifies if new objects are added or modified, grants are based on a schema. New tables will be accessible without specifically granting access to that table. It is still recommended […]Assigning Database Object Privileges- Users and Basic Security
Database object privileges allow you to access and manipulate other users’ objects. The types of database objects to which you can grant privileges include tables, views, materialized views, sequences, packages, functions, procedures, user-defined types, directories, and now with 23c schemas. To be able to grant object privileges, one of the following must be true: • […]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