With the article Query USER PRIVILEGES replicated, we can retrieve all ROLES, system PRIVILEGES, and object PRIVILEGES of a USER and construct the GRANT command assigning them to another USER. When a user is created in the Oracle database, if no roles or privileges are assigned, the user will not Read more…
With the article “Query for Oracle User Object Privileges,” we look at the object privileges assigned to a specific user in the Oracle database. In the Oracle database, there are two types of privileges: system privileges and object privileges. System privileges allow performing certain operations in the database, such as Read more…
The query in the article “Query for Oracle User Roles”, allows us to identify the ROLES assigned to a specific user in the Oracle database by selecting GRANTEE, which is the user receiving the role, and GRANTED_ROLE, which identifies the name of the role. A ROLE is a container for Read more…
The query in the “Assignment of DEFAULT_TABLESPACE Quota” article aims to create the command, through a dynamic query, to assign a user’s quota on their default_tablespace, considering the quota assigned to an existing user in the database. Every user created in the database has their own default tablespace, which is Read more…
The article “Query for Oracle User Password Status” allows you to view the password status of an account in the Oracle database. When an Oracle account is created, if a specific profile is omitted from the CREATE command, Oracle assigns the DEFAULT PROFILE to the created user. The DEFAULT PROFILE Read more…
With the article “Dynamic Query for Generating REBUILD INDEX Command,” we provide 2 dynamic queries through which we will have the possibility to create the rebuild command for indexes and partitioned indexes that are in the UNUSABLE state. REBUILD is the reconstruction of the index. This operation is performed when Read more…
Query to Check the Size of Partitioned Indexes With the article “Query Partitioned Indexes Oracle Size,” we’ll be able to verify the size of partitioned indexes. Effective and stable service in terms of performance relies on good data organization. Therefore, in large-scale environments, excellent data organization is essential to enable Read more…
Query to check the size of indexes With the article “Index Size Query,” we quickly examine the indexes and their sizes. Indexes are database objects that allow fast access to data. If there were no index on the table, queries would be very slow because they would read all the Read more…
With the article ” UNUSABLE Partitioned Indexes Query in Oracle”, we examine all the invalid indexes that point to partitioned tables in the database users. When it is necessary to delete a partition of a table with numerous partitions, great care must be taken during the drop of the partition. Read more…
With the article “UNUSABLE Indexes Query in Oracle,” we can quickly identify all the INVALID indexes in a SCHEMA. It may happen that, due to various factors, the indexes in a SCHEMA change status from USABLE to UNUSABLE. There are various factors indeed. One of the main causes can be Read more…