Discussions
Categories
- 384.6K All Categories
- 2.5K Data
- 556 Big Data Appliance
- 1.9K Data Science
- 451.4K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 561 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 166 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 536 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
How to stop machine name entering in v$session?
Hi guys,
When i am using the following tool SQL Developer, TOAD, PL/SQL Developer. I find my machine name in OSUSER in v$session.
Is there any possible way to stop these using TOAD, SQL Develope, PL/SQL Developer or is there any other tool that stop inserting machine name in OSUSER in v$session.
Thanks in advance
Best Answer
-
Why do you want to prevent the DBA from determining what machine you are connected from?
Given that this information is coming from your client machine, it is certainly possible to hack your machine so that it reports a different name assuming you have root/ Administrator access. But that's something that an attacker would normally want to do, not something that a normal user would want to do. That's why we're trying to determine why you are trying to hide this information.
Justin
Answers
-
Simple answer - no.
The machine name (and other client details) is set by the client driver. Not the client application.
BTW, why this requirement?
-
I am working in ORACLE 11 g Release 2 using PL/SQL Developer Tool
Every time i am logging in i could find my machine name in OSUSER in v$session table.
So i want to stop is there any other tool or any other way to stop it
-
Why do you want to prevent the DBA from determining what machine you are connected from?
Given that this information is coming from your client machine, it is certainly possible to hack your machine so that it reports a different name assuming you have root/ Administrator access. But that's something that an attacker would normally want to do, not something that a normal user would want to do. That's why we're trying to determine why you are trying to hide this information.
Justin
-
See when i am accessing via guest account it take the name into it. So i don't want to insert guest name instead it must enter my machine name or null.
-
So. What?
What is The Problem?
If you want to obfuscate what the OCI client driver reports to the server, you will need some low level hacks that are not easy and trivial. So why do you want to tackle such a hack complexity, instead of just doing your job via that database connection?