Hi Oracle Experts,
How can I check the Users who are online ?
Is there a table name which contains a list of DB users (e.g in
SQLServer the table is sysusers) ?
B.Dimple
Junior DBA 7 12077
B.Dimple wrote: Hi Oracle Experts,
How can I check the Users who are online ?
Is there a table name which contains a list of DB users (e.g in SQLServer the table is sysusers) ?
B.Dimple Junior DBA
select username, osuser from v$sessions;
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@fed1read03>... B.Dimple wrote: Hi Oracle Experts,
How can I check the Users who are online ?
Is there a table name which contains a list of DB users (e.g in SQLServer the table is sysusers) ?
B.Dimple Junior DBA
select username, osuser from v$sessions;
Thanks for the quick response.
Unfortunately, when I try your suggestion, I get this error message :-
"ORA-00942: table or view does not exist"
B.Dimple
B.Dimple wrote: "Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@fed1read03>...
B.Dimple wrote:
Hi Oracle Experts,
How can I check the Users who are online ?
Is there a table name which contains a list of DB users (e.g in SQLServer the table is sysusers) ?
B.Dimple Junior DBA
select username, osuser from v$sessions;
Thanks for the quick response.
Unfortunately, when I try your suggestion, I get this error message :- "ORA-00942: table or view does not exist"
B.Dimple
select username, osuser from sys.v$session
You have to be login as DBA (system or sys) to query V$session view.
Faheem
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6E_Jb.50538$BQ5.396@fed1read03>... B.Dimple wrote: "Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@fed1read03>...
B.Dimple wrote:
Hi Oracle Experts,
How can I check the Users who are online ?
Is there a table name which contains a list of DB users (e.g in SQLServer the table is sysusers) ?
B.Dimple Junior DBA
select username, osuser from v$sessions;
Thanks for the quick response.
Unfortunately, when I try your suggestion, I get this error message :- "ORA-00942: table or view does not exist"
B.Dimple
select username, osuser from sys.v$session
"Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6E_Jb.50538$BQ5.396@fed1read03>... B.Dimple wrote: "Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@fed1read03>...
B.Dimple wrote:
Hi Oracle Experts,
How can I check the Users who are online ?
Is there a table name which contains a list of DB users (e.g in SQLServer the table is sysusers) ?
B.Dimple Junior DBA
select username, osuser from v$sessions;
Thanks for the quick response.
Unfortunately, when I try your suggestion, I get this error message :- "ORA-00942: table or view does not exist"
B.Dimple
select username, osuser from sys.v$session
Hi Ana,
Thanks again.
B.Dimple
The select_catalog_role role might have to be granted.
Ping bd*****@myway.com (B.Dimple) wrote in message news:<eb*************************@posting.google.c om>... "Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6E_Jb.50538$BQ5.396@fed1read03>... B.Dimple wrote: "Ana C. Dent" <an*******@hotmail.com> wrote in message news:<6MFJb.47113$BQ5.3860@fed1read03>...
>B.Dimple wrote: > >>Hi Oracle Experts, >> >>How can I check the Users who are online ? >> >>Is there a table name which contains a list of DB users (e.g in >>SQLServer the table is sysusers) ? >> >>B.Dimple >>Junior DBA > >select username, osuser from v$sessions;
Thanks for the quick response.
Unfortunately, when I try your suggestion, I get this error message :- "ORA-00942: table or view does not exist"
B.Dimple
select username, osuser from sys.v$session
Hi Ana,
Thanks again.
B.Dimple
Dimple,
Looks like you do not have SELECT privileges on the V$session table.
Ask your DBA to give permissions. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Leszek |
last post by:
Hi everybody,
I need your help-I want to display all users which are online on my
web page and I don't know how to do this. I know how to do this whit
one IP but for more - I don't.
HELP ME...
|
by: RAD |
last post by:
I am working with an evaluation copy of SQL Server 2000 for the first
time; my DB experience lies with MS Access.
I have a simple table in SQL Server (tblCompany) that has a field
called...
|
by: Moti |
last post by:
Hello,
I am trying to check the integrity of SQL database. The 'problem' with
SQL server is that it's fixing the DB automatically after restore so I
need a way to do it offline, much like using...
|
by: Neil |
last post by:
I have a check box on a form that's bound to a function that returns a
True/False value. When the user clicks on the check box, I run some code
through the MouseDown event. Everything works fine.
...
|
by: TK |
last post by:
Excuse me for multiple posting because I've posted this message to
aspnet.security NG but have not got any response yet.
I'm building an ASP.NET application works in Forms Authentication mode...
|
by: Kittikun |
last post by:
I am currently using the BACKUP DATABASE method to backup my database.
Everything works fine, except for users. I created various users with
sp_addlogin to access this database and they are located...
|
by: Jeff |
last post by:
Hey
asp.net 2.0
I want to populate a GridView with a list of the online users, but I'm not
sure how to get the collection of online users:
I tryed using this code:
MembershipUserCollection...
|
by: Hemant Shah |
last post by:
Folks,
One of our clients is performing an audit, and the auditor(s) asked
following question, and I am not sure how to answer it:
28. Is there a control that prevents the corruption of...
|
by: B.Dimple |
last post by:
Hi Oracle Experts,
How can I check the Users who are online ?
Is there a table name which contains a list of DB users (e.g in
SQLServer the table is sysusers) ?
B.Dimple
Junior DBA
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |