| Author |
Message |
Mladen Gogala
*nix forums Guru
Joined: 11 Mar 2005
Posts: 948
|
 Posted: Mon May 15, 2006 3:09 am Post subject:
Re: no able to "set autotrace on" pls chk error
|
|
|
On Sun, 14 May 2006 15:17:06 -0700, DA Morgan wrote:
| Quote: | PS: Very bad form to grant CONNECT and RESOURCE. Learn to use specific
system and object privileges and/or create your own roles.
|
Especially bad thing is to grant resource. I believe it still implies
grant to UNLIMITED TABLESPACE, which empowers the recipient to create
anything anywhere. Also, there is no reason to allow the end-users to
create their own objects of any kind.
In other words, it's less about the form, more about the substance.
--
http://www.mgogala.com |
|
| Back to top |
|
 |
psoug
*nix forums Guru
Joined: 15 May 2005
Posts: 3492
|
| Posted: Sun May 14, 2006 10:17 pm Post subject:
Re: no able to "set autotrace on" pls chk error
|
|
|
peter wrote:
| Quote: | SQL> create user dump identified by dump;
User created.
SQL> grant connect,resource to dump;
Grant succeeded.
SQL> conn dump/dump@y2j
Connected.
SQL> @c:\oracle\ora90\rdbms\admin\utlxplan.sql
Table created.
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
enabled
SP2-0611: Error enabling STATISTICS report
I don't know how to solve this error pls help
|
A complete demo can be found in Morgan's Library at www.psoug.org
under Autotrace.
The PLUSTRACE role is granted using $ORACLE_HOME/rdbms/admin/plustrce.sql.
PS: Very bad form to grant CONNECT and RESOURCE. Learn to use specific
system and object privileges and/or create your own roles.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org |
|
| Back to top |
|
|
peter
*nix forums beginner
Joined: 06 May 2006
Posts: 36
|
| Posted: Sun May 14, 2006 4:44 pm Post subject:
Re: no able to "set autotrace on" pls chk error
|
|
|
Thank You Very Much
Problem is solved |
|
| Back to top |
|
|
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Sun May 14, 2006 12:29 pm Post subject:
Re: no able to "set autotrace on" pls chk error
|
|
|
"peter" <hhh.database@gmail.com> a écrit dans le message de news:
1147609193.095198.238090@j33g2000cwa.googlegroups.com...
| Quote: | There is no plustrace role or priv.
try: |
@?/sqlplus/admin/plustrce.sql
this create the PLUSTRACE role ... |
|
| Back to top |
|
|
peter
*nix forums beginner
Joined: 06 May 2006
Posts: 36
|
| Posted: Sun May 14, 2006 12:19 pm Post subject:
Re: no able to "set autotrace on" pls chk error
|
|
|
There is no plustrace role or priv.
but through sys
I can do this ( set autotrace on ) |
|
| Back to top |
|
|
Vincent M
*nix forums Guru
Joined: 22 Feb 2005
Posts: 1332
|
| Posted: Sun May 14, 2006 9:17 am Post subject:
Re: no able to "set autotrace on" pls chk error
|
|
|
| Quote: | SQL> create user dump identified by dump;
User created.
SQL> grant connect,resource to dump;
Grant succeeded.
SQL> conn dump/dump@y2j
Connected.
SQL> @c:\oracle\ora90\rdbms\admin\utlxplan.sql
Table created.
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
enabled
SP2-0611: Error enabling STATISTICS report
|
Try :
grant plustrace to dump; |
|
| Back to top |
|
|
peter
*nix forums beginner
Joined: 06 May 2006
Posts: 36
|
| Posted: Sun May 14, 2006 9:10 am Post subject:
no able to "set autotrace on" pls chk error
|
|
|
SQL> create user dump identified by dump;
User created.
SQL> grant connect,resource to dump;
Grant succeeded.
SQL> conn dump/dump@y2j
Connected.
SQL> @c:\oracle\ora90\rdbms\admin\utlxplan.sql
Table created.
SQL> set autotrace on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is
enabled
SP2-0611: Error enabling STATISTICS report
I don't know how to solve this error pls help |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
