× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Diksha.kushwah(*) reported 2015-07-28T13:55:16Z  · tariqrahiman last modified 2015-07-30T16:26:57Z

Debug permission not working for views in Role


Priority Low
Complexity Unknown
Component DB - Sap Hana
Version 17.0
Version: 17.0.0-dev-90
Build #: 44915
Build Date: 2015-Jul-25 06:02:49 PM
 
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072;  Total=657,981,440;  Free=140,571,904;  CPUs=8
 
Steps to reproduce:
 
Connect with SAPHANA
Create a Role using following script:
 
CREATE ROLE "role1"
GO
 
Create View Using following script:
 
CREATE TABLE "SYSTEM"."Booking_Details"  ( 
 "Booking_ID" INTEGER,
 "Employee_ID" VARCHAR(25),
 "Product_ID" VARCHAR(25),
 "Total_Units" INTEGER 
 )
GO
CREATE TABLE "SYSTEM"."Employee_Table"  ( 
 "Emplyee_Name" INTEGER,
 "Employee_ID" VARCHAR(25) NOT NULL,
 PRIMARY KEY("Employee_ID")
)
Go
 
CREATE VIEW "SYSTEM"."calculation_view" ("Booking_ID", "Employee_ID")
AS
SELECT A2."Booking_ID", A1."Employee_ID"
FROM "Employee_Table" AS A1
INNER JOIN "Booking_Details" AS A2 ON A1."Employee_ID"=A2."Employee_ID"
Go
 
Go to role1,Right click and seletc Alter role
Click on Object Permissions
Select views from Permissions for Objects option
Select System in Schema field
check Debug permission for calculation_view
 
Actual Result: An Error displayed "SAP DBTech JDBC: [460] (at 6): invalid privilege for object: DEBUG: line 1 col 7 
(at pos 6)"
1 attachment

Issue #13599

Closed
Fixed
Resolved 2015-07-30T00:44:53Z
 
 
Completion
No due date
Fixed Build v17.0.0-dev-95
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017