Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 26 Jul 2005 @ 13:34:02 GMT

  <Prev Next>  
Next> Last>>  

Subj:   GRANT role ON object WITH GRANT OPTION not allowed
From:   peter.n.gavin

I see in the SQL DDL manuals for v2r5.0.3 (our current release), v2r5.1.2 (anticipated as our next release) and in v2r6.1 (latest GA release) that one is not able to grant a Role on a table WITH GRANT OPTION.

Why is this so? I understand that the Role can be granted WITH ADMIN OPTION to a user and thus the user can grant another user on that Role, but what if I want to grant a role (say Usergroup_admin role) select with grant option on a table allowing them to grant this onwards to other roles/users?

This is a pretty serious limitation in my opinion...... or am I missing somthing very obvious?

NCR say that this is an ansi standard, but I was wondering how anyone out there gets around this without doing somthing like creating a seperate role for each table!



AIB Bank Republic of Ireland
Banking Systems

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020