Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

Can All Users Have The Privilege To Use The SQL Statement
Select (DML)?

Question Posted / guest

1 Answers
3731 Views
I also Faced
E-Mail Answers

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?..

Answer / s

If the SELECT privilege is granted to PUBLIC, Yes.
Otherwise privilege has to granted explicitly.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More DB2 Interview Questions

How to resolve -803 sql code in DB2?

3 Answers Cap Gemini,

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers HSBC,

What is a base table?

2 Answers

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers IBM,

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers Danske,

How to design maps

1 Answers Virtusa,

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers

What is cursor stability?

1 Answers

What is RUNSTATS?

3 Answers

How to find the maximum value in a column in the db2 database?