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
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
Oracle Projects is a propreitory name for a software by Oracle.
Oracle is relational DataBase
redo-is when you do sometyhing over! undo-is when u undo something
In Oracle 10g, the command used to establish a new user account is CREATE USER. The syntax typically looks like this: CREATE USER username IDENTIFIED BY password;, where "username" is the desired account name and "password" is the password for that account. After creating the user, you may also need to grant specific privileges using the GRANT command to allow the user to perform actions within the database.