REVOKE USER ROLE Oracle Database Tutorial Example

How To REVOKE ROLE from a USER In Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to revoke role from a user in Oracle Database Server as SYSDBA Tutorial Example

-- connect as sysdba
-- i am using sqlplus as client. you can use anything as you like.
 
   REVOKE DBA FROM TUTORIAL;
      -- that's it!! Oracle database user "TUTORIAL" DBA ROLE has been REVOKED
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To REVOKE ROLE from a USER In Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Disconnect From Oracle Database Tutorial Example
  2. How To Create Table In Oracle Database Tutorial Example
  3. How To Drop Table In Oracle Database Tutorial Example
  4. How To Truncate Table In Oracle Database Tutorial Example
  5. How To Insert Row In Oracle Database Table Tutorial Example
  6. MySQL IFNULL() Nested Function Example
  7. MySQL Stored Procedure Function: How to Drop a Function Example
  8. MySQL Sub-Query: CREATE TABLE SELECT *... Example
  9. 19 Examples to Learn MySQL
  10. 20 Steps to Learn CakePHP by Example

2 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Moreover, a typical transaction system is designed such that, each transaction is completely isolated from any and all transactions occurring in the database and at the same time, the results obtained from a transaction is required to comply with all restrictions imposed on the database.kpi dashboards

    ReplyDelete

leave your comments here..