can all users have the privilage to use the sql statement select * (dml)?
- 1 Answers
- 1258 Views
- IBM, I also Faced
- E-Mail Answers
Answer / Dharmendra Kumar Upadhyay
By default, not all users can use the SELECT * (DML) statement in DB2. The privileges are controlled by database administrators, and it is recommended to grant the minimum necessary privileges for security reasons. However, you can modify the privileges of a user to allow them to execute the SELECT * statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
can i code union in cobol-db2 pgm ?
How can you count the number of rows from a table tab?
What is a DBRM, PLAN ?
What keyword does an SQL SELECT statement use for a string search?
How to define the a field which accepts value till 99999.99 in db2
What is syscat in db2?
What db2 400?
What is an asychronous write?
Is db2 free?
Outputs of explain are with matchcols = 0. What does this signify?
Can there be more than one cursor open for any program?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
COBOL 
