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

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

Question Posted / s

Answer Posted / s

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is reorg?

617

Define db2.

670

What r the comman abends in db2, jcl and cobol???????

1818

Define db2 and its databases?

618

Can one database have multiple instances?

581

Are views updateable?

642

What is scrollable cursor in db2?

583

Can you tell me how can you find out the # of rows updated after an update statement?

610

Which component is responsible for processing sql statements and selecting access paths?

667

What is an instance database?

598

How many types of page locks can be held in db2?

589

What is alias in db2?

566

What do you mean by cursor?

584

What is plan in cobol db2?

589

On which levels locks can be applied?

656