Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to add "CREATE TEMPORARY TABLE" privilege in HDBROLE file?

former_member208191
Discoverer
0 Kudos

Hi,

I would like to know if there is a way to add the object privilege "CREATE TEMPORARY TABLE" to schema in design time role (HDBROLE). Because I have a stored proc which creates a local temporary table, now I need to create a role which allows using this SP. Meaning, allowing to create local temporary table.

Do you think that it is possible?

Best Regards,

Dinh

1 ACCEPTED SOLUTION

former_member208191
Discoverer
0 Kudos

Hi,

It will be available in SP11.

Best Regards, Dinh

1 REPLY 1

former_member208191
Discoverer
0 Kudos

Hi,

It will be available in SP11.

Best Regards, Dinh