× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
swapnil chaudhari
swapnil.chaudhari(*) reported 2014-02-24T06:08:02Z  · tariqrahiman last modified 2014-02-25T17:09:38Z

In Teradata Aster 6, multiple selection-> delete is not working for users having object permissions


Dev
Ivan Gron
ivangron
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - Visual Editing
Version 14.0
Aqua Data Studio 14.0.8
Build #: 35460
Built on: 2014-Jan-09 08:51:14 AM     
 
Database: Teradata Aster 6
Windows 7:64 bit
 
Step1 : Create a database.
CREATE DATABASE beehive
WITH ENCODING = 'UTF8'
GO
 
Step 2 : Create a user.
CREATE USER "user1" WITH INHERIT PASSWORD 'password'
GO
GRANT CREATE ON DATABASE "beehive" TO "user1"
GO
GRANT CONNECT ON DATABASE "beehive" TO "user1" WITH GRANT OPTION
GO
GRANT "process_admin" TO "user1" WITH ADMIN OPTION
GO
GRANT "process_runner" TO "user1"
GO
GRANT "process_viewer" TO "user1"
GO
 
Step 3: Create 1 more user.
 
CREATE USER "user2" WITH INHERIT PASSWORD 'abc123'
GO
GRANT CREATE ON DATABASE "beehive" TO "user2" WITH GRANT OPTION
GO
GRANT "node_admin" TO "user2" WITH ADMIN OPTION
GO
GRANT "node_viewer" TO "user2"
GO
GRANT "process_admin" TO "user2"
GO
 
Step 4: 
Go to user1
Right click on it.
Select Alter user
Click on Object permissions
Grant permissions (select, insert etc.) to "user1"
Click on alter button.
(
GRANT INSERT ON TABLE "nc_system"."nc_errortable_part" TO "user1"
GO
GRANT UPDATE ON TABLE "nc_system"."nc_errortable_part" TO "user1" WITH GRANT OPTION
GO
GRANT UPDATE ON TABLE "nc_system"."nc_errortable_repl" TO "user1" WITH GRANT OPTION
GO
)
 
Step 5:
Multiselect "user1" and "user2"
Right click on it
select "delete" option.
 
Step 6:
"user2" dropped successfully but "user1" is not dropped.
This is because, In SQL log drop script is generated with revoke script on databases only but revoke script for Object permissions is not generated.
However when we drop single user, in SQL log it generates revoke script for object permissions also. 
1 attachment
  •  
  •  
  • No shares
  •  
All Comments (1) Change History
Sort 

Issue #11758
Closed
Won't Fix
Resolved 2014-02-25T01:11:49Z
 
 
Completion
No due date
No fixed build
No time estimate

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