topic Re: SQVI in Application Development and Automation Discussions

SQVI

Former Member — Fri, 17 Jul 2009 16:01:44 GMT

Is there a risk of giving users access to SQVI in production. If so, what are they?

Re: SQVI

jurjen_heeck — Fri, 17 Jul 2009 16:12:23 GMT

> Is there a risk of giving users access to SQVI in production. If so, what are they?

1- performance, there's no way an enduser will know what the penalty on querying big tables can be (or which are the big tables).

2- security. Table security is a lot less granular than application security in most cases.

3- data misinterpretation. Endusers may well guess which tables contain valid data.

And I'm afraid that's just the tip of the iceberg. A better approach will be to see which queries are needed and whether SAP query can do the job or a report needs to be programmed. In both cases these would be linked to transactions and granted to the relevant users via these transactions.

SQVI is little more than a quick and dirty prototyping tool in my opinion. Prototyping isn't done on production systems.....

Re: SQVI

Former Member — Fri, 17 Jul 2009 16:13:58 GMT

This message was moderated.

Re: SQVI

Former Member — Fri, 17 Jul 2009 16:24:11 GMT

Vikas,

Risk is always associated with each transaction which are giving in production systems .But if we will not give any tcode to any user ,How we will work !!!:-)

I am totally aware of that.....Obviously you will not have a job if we were allowed to give every transaction in production, right. Thank your lucky stars that there is such thing as Security because you have a JOB.......LOL

Re: SQVI

Former Member — Fri, 17 Jul 2009 16:27:55 GMT

Daisy,

Nothing to react over there....I just tried to solve your query ..

Anyway ..Sorry ,not able to response your query in correct way .

Regards

Re: SQVI

Former Member — Fri, 17 Jul 2009 19:14:06 GMT

Thank you very much Jurgen Heeck.