User defined SQL permission

[Dipika Dabhakdar]

Hello experts,

I want to grant just one person access to 'user define SQL' feature and it is just for one Cognos package, This person is not part of any existing group and I don't want to create a new group specially for that person.
how do I get that person access to the user defined SQL ?


Thanks, Appreciate your help!

[bdbits]

You would do this the same way you give a group permissions. What you might be missing is the little checkbox at the top of the group/user selection dialog to "Show users in the list". Then pick the user just as you would a group and assign the permissions.

[Dipika Dabhakdar]

Thanks bdbits!

I exactly followed the same steps to give access to a user, but now when we test in the report studio to check if the feature is working by simply typing a Select * From query it gives me following error;

"The server returned an unrecognizable query framework response", RQP-DEF-0149 The query specification is incorrect

[MFGF]

Thanks bdbits!

I exactly followed the same steps to give access to a user, but now when we test in the report studio to check if the feature is working by simply typing a Select * From query it gives me following error;

"The server returned an unrecognizable query framework response", RQP-DEF-0149 The query specification is incorrect

Did you specify a data source in the properties of the SQL?

MF.

[Dipika Dabhakdar]

Yes I did and now its working. It was a silly mistake, I had the table name wrong