User DB with User NT

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jorge Pinto
    #1

    User DB with User NT

    Hey folks,

    I have an user A connected to database DB. On NT this user is logged as B.
    So, I want to create a trigger to see when the user tries to connect the
    database, it checks to see if user connection and user logged on NT is the
    same.

    Do I have a variable that returns my user logged on NT ?
    My set variables has the user connect on NT, so is there any possibility to
    read this variable on the server ??

    Thanks in advance,

    JP


    Tags: None
    • Jorge Pinto
      #2
      Re: User DB with User NT

      I think it's Oracle 8i (8.1)


      "s.kapitza" <skapitza@volca nomail.comwrote in message
      news:26703915.0 306251001.3b8c7 2da@posting.goo gle.com...
      hi,
      >
      osuser in v$session might what you are after.
      >
      the rest depends on your Oracle Version.
      >
      regards
      >
      s.kapitza
      >
      "Jorge Pinto" <jorgep@sympati co.cawrote in message
      news:<mL7Ka.305 6$Fe3.536108@ne ws20.bellglobal .com>...
      Hey folks,

      I have an user A connected to database DB. On NT this user is logged as
      B.
      So, I want to create a trigger to see when the user tries to connect the
      database, it checks to see if user connection and user logged on NT is
      the
      same.

      Do I have a variable that returns my user logged on NT ?
      My set variables has the user connect on NT, so is there any possibility
      to
      read this variable on the server ??

      Thanks in advance,

      JP

        Comment

        • Jorge Pinto
          #3
          Re: User DB with User NT

          My real case is I have a trigger that checks the time that the user is
          trying to connect the db and depends on it, I reply to the user's email an
          error and the user is not allowed to connect to it.... The user'smail is the
          same as his/her login on NT!!!

          Thanks in advance....


          "Jorge Pinto" <jorgep@sympati co.cawrote in message
          news:mL7Ka.3056 $Fe3.536108@new s20.bellglobal. com...
          Hey folks,
          >
          I have an user A connected to database DB. On NT this user is logged as B.
          So, I want to create a trigger to see when the user tries to connect the
          database, it checks to see if user connection and user logged on NT is the
          same.
          >
          Do I have a variable that returns my user logged on NT ?
          My set variables has the user connect on NT, so is there any possibility
          to
          read this variable on the server ??
          >
          Thanks in advance,
          >
          JP
          >
          >

            Comment

            • Charles
              #4
              Re: User DB with User NT

              You can create this user with parameter 'EXTERNAL'. The Oracle
              authentication is then passed onto the NT. Therefore, eliminating the need
              of creating a trigger.

              Charles
              "Jorge Pinto" <jorgep@sympati co.cawrote in message
              news:mL7Ka.3056 $Fe3.536108@new s20.bellglobal. com...
              Hey folks,
              >
              I have an user A connected to database DB. On NT this user is logged as B.
              So, I want to create a trigger to see when the user tries to connect the
              database, it checks to see if user connection and user logged on NT is the
              same.
              >
              Do I have a variable that returns my user logged on NT ?
              My set variables has the user connect on NT, so is there any possibility
              to
              read this variable on the server ??
              >
              Thanks in advance,
              >
              JP
              >
              >

                Comment

                Previous template Next
                Working...