Today's Messages (on)  | Unanswered Messages (off)

Forum: Forms
 Topic: LOGON function
Re: LOGON function [message #679812 is a reply to message #679811] Tue, 31 March 2020 03:39
Littlefoot
Messages: 21547
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Here's a walkthrough which shows what you have, what you should (and should not) do to make it work.

Connected as SCOTT, I can't select from v$session:
SQL> show user
USER is "SCOTT"
SQL> select count(*) from v$session;
select count(*) from v$session
                     *
ERROR at line 1:
ORA-00942: table or view does not exist
Connect as a privileged user (it is SYS in my test XE database; use your own user you use for such purposes) and grant SELECT. Note the difference!
SQL> connect sys as sysdba
Enter password:
Connected.
SQL> grant select on v$session to scott;
grant select on v$session to scott
                *
ERROR at line 1:
ORA-02030: can only select from fixed tables/views


SQL> grant select on v_$session to scott;

Grant succeeded.
Back to SCOTT:
SQL> connect scott
Enter password:
Connected.
SQL> select count(*) from v$session;

  COUNT(*)
----------
        24

SQL>

[Updated on: Tue, 31 March 2020 03:41]

Report message to a moderator




Current Time: Tue Mar 31 08:31:47 CDT 2020