Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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!


Thanks,

Pete

AIB Bank Republic of Ireland
DBA
Banking Systems



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