Grant component privilege fails with syntax error with reserved words as priv_name

Bug #1376894 reported by Paul Low
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Released
Medium
Cliff Gray

Bug Description

The following statements return syntax errors:

GRANT COMPONENT PRIVILEGE DROP
ON SQL_OPERATIONS TO PUBLIC;

GRANT COMPONENT PRIVILEGE “DROP”
ON SQL_OPERATIONS TO PUBLIC;

GRANT COMPONENT PRIVILEGE CREATE
ON SQL_OPERATIONS TO PUBLIC;

GRANT COMPONENT PRIVILEGE ALTER
ON SQL_OPERATIONS TO PUBLIC;

Tags: sql-security
Cliff Gray (cliff-gray)
Changed in trafodion:
status: New → In Progress
Cliff Gray (cliff-gray)
Changed in trafodion:
assignee: nobody → Cliff Gray (cliff-gray)
Cliff Gray (cliff-gray)
Changed in trafodion:
status: In Progress → Fix Committed
Paul Low (paul-low-x)
Changed in trafodion:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.