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!
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.
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
Quote from: Sweety on 02 Sep 2015 03:49:50 PM
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.
Yes I did and now its working. It was a silly mistake, I had the table name wrong