disable select on table

[Former Member]

Hi all,

is it possible to suppress select on table for developers.

Eg. IF developer input this statment

select * from kna1 into table lt_kna1.....

he need to get empty lt_kna1.

This should be done on role level or?

[Former Member]

I don't think its possible. Either you can restrict SE38 access/ SE11/Se16 access, But in program we can't avoid only Select statement and for particular table

Regards

Sasi

[Former Member]

ok , how to supprss selec on some tables eg. pa008

[vinod_vemuru2]

Hi Nick,

Best option i can sugest is create Authorization object for the table u want to restrict.

In program select the data only if the user has the access to that table.

eg: AUTHORITY-CHECK object xxx

IF sy-subrc IS INITIAL.

Select from ur table.

else.

message 'U don't have authorization'.

ENDIF.

Hope it is clear.

Thanks,

Vinod.

[Former Member]

Hi Nick,

I suppose you dont want to restrict an ABAPer from taking a look at any data. Because if you do so then definitely they can bypass any check through debugging.

If your intention is to stop end user then just have an authority check for the report itself where you are populating such data.

You could explain your problem so that we could suggest some workaround.

Regards,

[piyush_mathur]

Hi...

Another option to stop to acess the data from Databse is use LDB. So if user is not authorized to access the data from a table, he will got get data.

Regards,

Piyush