User created tables and permisisons

[Harold]

Good morning all, I was wondering if anybody had any insight on the following scenario:

When I create a new persistent class, I am not automatically granted any SQL privileges by default.  For some reason, I can still utilize the SQL queries when I've incorporated them into ClassMethods, but I get the following when trying to run any queries against it using the SQL Command Line Shell:

ENSEMBLE>>select * from Sample.SQLProjection

 

ERROR #5540: SQLCODE: -99 Message: User xxxx is not privileged for the operation

The only workaround that i know of at this point is to have one of our DBAs grant us the proper permissions for each and every table.  It's cumbersome to say the least.

Thanks!

Harold

[peter cooper]

Hi Harold

 

You can do something like this in embedded SQL

                &sql(grant SELECT,INSERT,UPDATE,DELETE on * to some_user)

Peter

--
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare Community" group.
To post to this group, send email to Ensemble-in...@googlegroups.com
To unsubscribe from this group, send email to Ensemble-in-Healt...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/Ensemble-in-Healthcare?hl=en
---
You received this message because you are subscribed to the Google Groups "InterSystems: Ensemble in Healthcare" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Ensemble-in-Healt...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.