How to put security on grids?

Applications Grid / Reports
#1

Hi,

I would like to know how to put security on grids based on user level? Where will I put my sc_look_up macros for SQL statement?

Thanks
ishey

#2

Re: How to put security on grids?

Hi Ishey,

may be, I would put the user with its level into gobal variables and look for that in the OnInit event. Just if you want to give
another option like inserting a special password. Normally it should work wonderfull with the security option described in the
manual.

Best regards

#3

Re: How to put security on grids?

Hi EricB,

Thanks for replying. I already had the userlevel field as a global variable. So I will have to put my SQL statement on the OnInit Event of a grid?

Also I had a problem with the sc_app_status. The said macro isn’t working for me… I really need to put security on my forms…

Thanks
ishey

#4

Re: How to put security on grids?

As User of SC, I have to confirm that I had problems with the security option as described in the documentation as well.
But after retyping everything stp by step and thinking of the meaning of it (also correction some typos made by me) I have
to say it is working great and easy. Best would be to try to get it runnig and to include the security as described in the documentation.

The SQL statement should be in the onLoad event. onInit was my first idea of checking if the user is valid or not.

Best regards

Eric

#5

Re: How to put security on grids?

Hi Eric,

OK. I’ll try doing the same thing as u’ve said.

What do you mean retying everything step by step?

uhm how about putting security on a tree menu…, its possible right? I want to hide and unhide a couple of forms based on userlevels…

Thanks
ishey

#6

Re: How to put security on grids?

as a hint, you find the sample security application in the samples of your SC installation.
If it really does not work with what you did, may be you can copy these application into your project.

Best regards

Eric