About audits in Oracle 11g

oracle-11g-r2

I need to do the auditing in database, but different the normal process that administrator use, (active audit in first installation or alter ) I don't have time window for this.

My scenario:
tree users with select grant just. But, for others users in same place, using the global user whit delete, update grant.

And I don't simply change the grant these users, because others applications use in font the same user and password.

Exist other form that I take a report with , what each one user does in database?

Best Answer

You're right, excuse any errors or agreement error.

My question is a concept so much, but explain.

I have users who have their logins, but there is a login that has some privileges that also and the same User used in important processes in the environment and is in source code.

At one point in the past knew the password for this login, and the more I say to access the environment with their respective login and password in some cases, they use this login with privileges.

As I have not, by default, a native audit Oracle configured in my environment, I wonder if through tables and views I can map out what such User made using a PL SQL DEVELOPER. The worst and I have no time available to make this change, let offline the database, adjust and available.

Related Solutions

Getting error installing oracle 11gR2: cannot access node

It looks like the hardening was a little to hard. Oracle does need some access to the server. You can revert back the chmods for ping, Oracle rdbms does not need it. /tmp/ is not required, a usable location for tmp is, mostly for scripting. The rdbms has it's own tricks and storage for sorts.

Never install Oracle as root; use the root.sh at the end of the installation to do the system tweeks required. On some platforms there is a root pre script that should run before installation. The Oracle installation scripts refuse to run using the root account and can be run using any other account.

The access to some server config files has been made a little too tight for the install user to check the prerequisites. If you know they are ok, it's ok. Proving they are ok is a little easier when support issues arise. Check the group ownership of the critical config files and add the Oracle installation user to that group to give it read access.

Oracle 11g – Create Database fails

One of the key differences between these platforms is that a database in MySQL is a schema in Oracle. Since a schema in Oracle is also a user, the command you are looking for is CREATE USER. I highly recommend that you read the Oracle Concepts Guide before continuing. You may also find this documentation on MySQL>>Oracle migrations using SQL Developer useful. Here is the part relevant to your situation:

When migrating MySQL databases to Oracle, SQL Developer maps each MySQL database to a tablespace in Oracle. Database objects, such as tables, indexes and views are stored in the respective tablespaces and are referenced from the Oracle schema for the user that owns them.

From the error message perspective, the salient part to pull out is "ORA-01100: database already mounted". This indicates that a database has already been created and mounted. It may also be open. Here is an example reproducing your issue, opening the database (which may not be necessary if it is already open) and creating a django user.

SQL> create database django;
create database django
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted


SQL> SELECT status FROM v$instance;

STATUS
------------
MOUNTED

SQL> ALTER DATABASE OPEN;

Database altered.

SQL> SELECT status FROM v$instance;

STATUS
------------
OPEN

SQL> create database django;
create database django
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted


SQL> CREATE USER django IDENTIFIED BY "No More ORA-001100.";

User created.

You should also assign permissions and create a django tablespace setting it as the default tablespace for django.

Best Answer

Related Solutions

Getting error installing oracle 11gR2: cannot access node

Oracle 11g – Create Database fails

Related Question