answersLogoWhite

0

Use the Oracle revoke command

Example: revoke execute on procedure from user;

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Use of commit and rollback in oracle?

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.


How do you create a user in oracle 10g?

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.


What are modules of oracle?

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.


What is the meaning of i in oracle 9i?

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....


Who is the author of oracle?

Oracle is a product from Oracle corporation. www.oracle.com


What is oracle 12c?

Oracle r12 is Oracle release 12.


What is the Difference between undo and do?

do means you do it and undo means to undo or get ride of it


What is oracle projects?

Oracle Projects is a propreitory name for a software by Oracle.


The meaning of Oracle is?

Oracle is relational DataBase


When should you create a role in Oracle?

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


What is undo and redo?

redo-is when you do sometyhing over! undo-is when u undo something


What is oracle certification?

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