DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: TOAD & ORACLE DATABASE

  1. 04-25-2002, 06:52 PM #1
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Hi all,
    We have TOAD and another reporting application on our database.
    Few users have access to TOAD and we are concerned that they might delete or drop a table in the database. All of the users were created in the reporting application which only read, write and delete privilege. How can we enhance the databsae security through
    toad or ?
    Any suggestion?
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
    Reply With Quote Reply With Quote
  2. 04-26-2002, 12:22 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    As you mentioned reporting application then I assume that the users do not need insert, update, delete privileges. You may revoke them and just make sure that the select privilege is granted on the tables, views.
    Or you may create a role for reporting application and grant it to the application users.

    Sanjay
    Reply With Quote Reply With Quote
  3. 04-28-2002, 05:44 PM #3
    Ablakios
    Ablakios is offline Senior Member
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374
    Thanks Sanjay
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
    Reply With Quote Reply With Quote
  4. 04-28-2002, 06:27 PM #4
    eyen
    eyen is offline Member
    Join Date
    Jun 2000
    Posts
    117

    Talking

    TOAD also has security within itself.
    Tools -> Toad Security


    If you need more detail e-mail me at
    eric.yen@quest.com
    E. Yen
    OCP DBA 8, 8i, 9i
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width