Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Restrict Users not to see table

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    31

    Restrict Users not to see table

    Is there any way or some mechanism to restrict user not to see the table say payroll table because it contains salary column and client does not want to allow other users (say Developer) to see such piece of information. Through Grant option and role option how can it be achieved?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Use object leel privileges - example -

    Revoke select on <owner>.<tablename> from <user>

+ Reply to Thread

Similar Threads

  1. Recyclebin with Flashback Table in Oracle 10g
    By devesh_ocp in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 04-26-2012, 02:21 PM
  2. Partitioning a table from a normal table
    By devesh_ocp in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 04-24-2012, 04:06 PM
  3. Oracle 11gR2 Table level compression.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-25-2012, 02:53 PM
  4. Oracle 10g Free up Unused Table Space.
    By ajaychandi in forum Database Performance Management,Database Links,Materialized Views
    Replies: 0
    Last Post: 01-25-2012, 02:48 PM
  5. status_code and phase_code in FND_CONCURRENT_REQUESTS table
    By Hemant in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 10-31-2011, 07:24 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics