showddl statements executed by non db__root user returns error 4481
Bug #1427869 reported by
Paul Low
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
Fix Released
|
High
|
Cliff Gray |
Bug Description
Security is enabled. User (non db__root user) with MANAGE_USER or SHOW privilege should be able to execute SHOWDDL statements, but the following error is being returned:
SQL>showddl user username1;
*** ERROR[4481] The user does not have SELECT privilege on table or view TRAFODION.
This issue was found while verifying fix for Bug 1414234.
Changed in trafodion: | |
status: | New → In Progress |
To post a comment you must log in.
Fixed as of change 1296.