Use the Oracle revoke command
Example: revoke execute on procedure from user;
In Oracle, you can insert rows, update rows or delete rows from tables, but the changes are only current to your session. That means that if you insert a row in a table, no other users will be able to see it until you enter a COMMIT command. If you should enter or delete information by mistake, you have the chance to undo your changes by using the ROLLBACK command. The ROLLBACK will undo changes to data since the last COMMIT was executed.
To create a user in Oracle 10g, you can use the SQL command CREATE USER. For example, you can execute CREATE USER username IDENTIFIED BY password; to create a new user with a specified username and password. After creating the user, you typically need to grant privileges using the GRANT command, such as GRANT CONNECT, RESOURCE TO username;, to allow the user to log in and perform actions in the database.
Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM, Oracle Projects, Oracle CRM, Oracle Procurement.
The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....
Oracle is a product from Oracle corporation. www.oracle.com
Oracle r12 is Oracle release 12.
do means you do it and undo means to undo or get ride of it
Oracle Projects is a propreitory name for a software by Oracle.
Oracle is relational DataBase
I think role is for these two purposes. 1>to grant a group of related privileges to a user 2>to simplify the process of granting and revoking privileges
redo-is when you do sometyhing over! undo-is when u undo something
The Oracle Certification Program is a professional certification program offered by the Oracle Corporation. There are three levels of Oracle Certification in several disciplines: Oracle Certified Associate (OCA), Oracle Certified Professional (OCP), and Oracle Certified Master(OCM). Wikipedia