Permission for sequence

ratheeshknair · #1 (**permalink**) 12-09-09, 00:17

Hi Experts,

How can i grant permission to sequences from control center?

Now i am using script to achieve the same which is a tedious task as i have write the GRANT USAGE ON SEQUENCE sequence_name TO user; for all sequences.We aer using more than 200 sequences.

Please Help

TIA

przytula_guy · #2 (**permalink**) 12-09-09, 04:19

all info can be retrieved from catalogs
a simple query like select 'grant usage on sequence '||seqname.... from sysibm.syssequences
would generate these statements for you
have a look at this table

ratheeshknair · #3 (**permalink**) 12-10-09, 02:03

Thanks Guy Przytula,

Is there any way to achieve the same from control center?

TIA

Internet Services

Web Development

Digital Marketing

Consumer Tech