OraFAQ Forum: Server Administration » created sequence not visible

Home » RDBMS Server » Server Administration » created sequence not visible (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 ; AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

created sequence not visible [message #661421]

Fri, 17 March 2017 02:30

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
------------------------------ ------------------------------ ---------- ---------- ------------ ---------- ---------- ---------- -----------

Report message to a moderator

Re: created sequence not visible [message #661422 is a reply to message #661421]

Fri, 17 March 2017 02:32

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

Report message to a moderator

Re: created sequence not visible [message #661423 is a reply to message #661422]

Fri, 17 March 2017 02:36

John Watson
Messages: 8960
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

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.

Report message to a moderator

Re: created sequence not visible [message #661426 is a reply to message #661425]

Fri, 17 March 2017 03:08

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: created sequence not visible [message #661427 is a reply to message #661425]

Fri, 17 March 2017 03:12

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Have you noticed that there is something wring with your keyboard? It inserts multiple "..." characters.

Report message to a moderator

Re: created sequence not visible [message #661428 is a reply to message #661426]

Fri, 17 March 2017 03:14

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

Report message to a moderator

Re: created sequence not visible [message #661429 is a reply to message #661427]

Fri, 17 March 2017 03:17

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

Report message to a moderator

Re: created sequence not visible [message #661440 is a reply to message #661428]

Fri, 17 March 2017 11:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: created sequence not visible [message #663663 is a reply to message #661440]

Tue, 13 June 2017 15:19

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

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.

Report message to a moderator

Re: created sequence not visible [message #663666 is a reply to message #663664]

Wed, 14 June 2017 00:51

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I suspect a more complete analysis has already been posted.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 03:01:30 CST 2024