Home » RDBMS Server » Server Administration » created sequence not visible (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 ; AIX)
created sequence not visible [message #661421] Fri, 17 March 2017 02:30 Go to next message
oratech10
Messages: 26
Registered: September 2011
Junior Member

command i executed:
SQL> create sequence CSPROD.DEALID_US777_OF
2 minvalue 10001
3 maxvalue 999999999999999999999999999
4 start with 30881
5 increment by 1
6 cache 20;

Sequence created.

SQL> select * from all_sequences where sequence_name like '%DEALID_US777_OF%';

SEQUENCE_OWNER SEQUENCE_NAME MIN_VALUE MAX_VALUE INCREMENT_BY CYCLE_FLAG ORDER_FLAG CACHE_SIZE LAST_NUMBER
------------------------------ ------------------------------ ---------- ---------- ------------ ---------- ---------- ---------- -----------
Re: created sequence not visible [message #661422 is a reply to message #661421] Fri, 17 March 2017 02:32 Go to previous messageGo to next message
oratech10
Messages: 26
Registered: September 2011
Junior Member
When I try to create sequence again, without dropping..then it says object already exists. Please let me know where this sequence is residing? thanks
Re: created sequence not visible [message #661423 is a reply to message #661422] Fri, 17 March 2017 02:36 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Please read How to use [code] tags and make your code easier to read You have been asked to do this before.

It would seem probable that your schema has been granted CREATE ANY SEQUENCE but has not been granted SELECT ANY SEQUENCE.

[Updated on: Fri, 17 March 2017 02:37]

Report message to a moderator

Re: created sequence not visible [message #661425 is a reply to message #661423] Fri, 17 March 2017 03:01 Go to previous messageGo to next message
oratech10
Messages: 26
Registered: September 2011
Junior Member
I am able to select other sequence except this. Not sure why this sequence alone I am not able to see. Actually this was created long back but since in application error logs, it says sequence does not exist, so tried to create again however it said object already exists, thus we dropped and recreated..however still we cannot find this sequence..all other sequences we able to view... Not sure what went wrong with this sequence alone...we are not able to view only this sequence.
Re: created sequence not visible [message #661426 is a reply to message #661425] Fri, 17 March 2017 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I am able to select other sequence except this.
Because you have been granted the privilege to do so.


Quote:
Not sure why this sequence alone I am not able to see
Because you have not the SELECT ANY SEQUENCE as John said.

Quote:
it says sequence does not exist, so tried to create again however it said object already exists,
It says that because you have not the privilege to access it.

Re: created sequence not visible [message #661427 is a reply to message #661425] Fri, 17 March 2017 03:12 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Have you noticed that there is something wring with your keyboard? It inserts multiple "..." characters.
Re: created sequence not visible [message #661428 is a reply to message #661426] Fri, 17 March 2017 03:14 Go to previous messageGo to next message
oratech10
Messages: 26
Registered: September 2011
Junior Member
Thank you so much.. when I checked with high privilege ID I can see this sequence..finally given grant select any sequence to app user and can view the sequence now. Thank you so much guys Smile
Re: created sequence not visible [message #661429 is a reply to message #661427] Fri, 17 March 2017 03:17 Go to previous messageGo to next message
oratech10
Messages: 26
Registered: September 2011
Junior Member
Have you noticed that there is something wring with your keyboard? It inserts multiple "..." characters.

Oh this. I wantedly given, nothing wrong with keyboard Smile
Re: created sequence not visible [message #661440 is a reply to message #661428] Fri, 17 March 2017 11:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
finally given grant select any sequence to app user
This is not a solution, this is a security bug.
NO app user should have an ANY privilege.

Re: created sequence not visible [message #663663 is a reply to message #661440] Tue, 13 June 2017 15:19 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
Never give any elevated privileges to an application user. Simply issue a grant select on the new sequence to the application schema. You have opened a big security hole with your grant. Sorry Michel. I just noticed you saying the same thing.

[Updated on: Tue, 13 June 2017 15:20]

Report message to a moderator

Re: created sequence not visible [message #663664 is a reply to message #661421] Wed, 14 June 2017 00:47 Go to previous messageGo to next message
prabhakarkamath
Messages: 15
Registered: February 2006
Junior Member
Few additional points:

1. You can make use of table DBA_SEQUENCES (you may need admin access)
2. I suspect you are creating it from USER1 and sequence is in USER2. So, check whether you logged in with the user with the same user as owner of the sequence.

Hope this helps.
Re: created sequence not visible [message #663666 is a reply to message #663664] Wed, 14 June 2017 00:51 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I suspect a more complete analysis has already been posted.

Previous Topic: Finding Error message list
Next Topic: How identify Schedule Object triggered in job with 2 associated schedules
Goto Forum:
  


Current Time: Fri Mar 29 05:09:36 CDT 2024