User privileges (Newbie question)

dstachon · #1 (**permalink**) 09-22-04, 09:25

Hi,

Without actually attempting either an UPDATE, INSERT, SELECT or DELETE on a certain table, how can I determine what operations I have the privilege to perform on that object?

(DB2 7.2 on AIX)

thanks.

n_i · #2 (**permalink**) 09-22-04, 09:36

Code:

select * from syscat.tabauth where grantee='YOURUSERNAME' and tabschema='YOURSCHEMA' and tabname='YOURTABLE';

dstachon · #3 (**permalink**) 09-22-04, 09:43

great thanks.....you've improved my opinion of Toronto ;-)

n_i · #4 (**permalink**) 09-22-04, 10:07

Quote:

Originally Posted by dstachon

.....you've improved my opinion of Toronto ;-)

Well, you've confirmed my opinion of Ottawa

Internet Services

Web Development

Digital Marketing

Consumer Tech