topic Re: disable select on table in Application Development and Automation Discussions

disable select on table

Former Member — Fri, 26 Dec 2008 09:13:12 GMT

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?

Re: disable select on table

Former Member — Fri, 26 Dec 2008 09:17:26 GMT

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

Re: disable select on table

Former Member — Fri, 26 Dec 2008 09:19:26 GMT

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

Re: disable select on table

vinod_vemuru2 — Fri, 26 Dec 2008 09:23:10 GMT

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.

Re: disable select on table

Former Member — Fri, 26 Dec 2008 09:44:20 GMT

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,

Re: disable select on table

piyush_mathur — Fri, 26 Dec 2008 10:06:05 GMT

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