Flemming Frandsen wrote: > > Sven K�hler wrote: > > OK, but how can someone query data from the layer without > > using SQL? i would have to write half of the application - > for example > > one function for each situation/query. > > That's to much work for me. My client won't pay for that. > > Well, then that idea is out:) > > > > Such a script would be nice, but i can't find a table that > contains ALL > > foreign-keys of ALL users. > > Hmm, then you may need to have the script to log in as each of the > "untrusted" users and check that they obey their > constraint-constraints, > but someone on the sapdb list may know how to get every constraint.
The owner of a table and all users who have the 'reference'-privileg are allowed to see the referential constraints for a table. Therefore you have to check the referential constraints for each user (one by one) for whom you want to assure that no '... restrict' will stop him from working. The systemviews are only views in a special way. There ist no table underlying for which a trigger could be defined. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
