How to list all seqeunces?

Aster

How to list all seqeunces?

There is not system view to list all sequences.

I found some information inside nc_all_columns but Aster provides GRANT on sequence without simple way to identify their names.

2 REPLIES

Re: How to list all seqeunces?

Hi,

One possible way is to list down all the columns with serial data type from nc_all_columns.

Br,

Khurram

Khurram

Re: How to list all seqeunces?

Could you provide an example use this name to get next value and grant access to sequence to other user?