+ Reply to Thread
Results 1 to 3 of 3

Thread: revoke

  1. 05-13-2002 09:11 AM #1
    vbaskar
    vbaskar is offline Member
    Join Date
    Jan 2001
    Posts
    153
    Hi All,

    I dont want users A,B,C,D to connect to user Z,Y,Q. How can i accomplish this.

    Rgds
    Vijay.s
    Reply With Quote Reply With Quote
  2. 05-13-2002 09:19 AM #2
    rohitsn
    rohitsn is offline Advisor
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    Which version of Oracle you are using.If you are using Oracle 8i and above you can write database or schema level triggers to restrict users to connect the Z,Y,Q users or else dont give the passwords of Z,Y,Q to user A,B,C,D.

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com
    Reply With Quote Reply With Quote
  3. 05-13-2002 09:28 AM #3
    vbaskar
    vbaskar is offline Member
    Join Date
    Jan 2001
    Posts
    153
    Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    PL/SQL Release 8.1.7.0.0 - Production
    CORE 8.1.7.0.0 Production
    TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production
    Vijay.s
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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