I have a business unit system, ORACLE database, and is limited to my department to use, and the other department will come to query some of our data, often when they unit leadership is friends, use PB made a small program related queries, so convenient he query, this small program is equal to the external business system,
Now friends, I don't want to let them continue to use this small program, department how to let they don't have access to our database? Or, can't access the database and query data? That is to say, let I used to do "little plugin" failure,
Ask everybody to help!
(don't change the database password, because this way, the original business system will be affected)

CodePudding user response:

Query small program for user? Any change to the user's password can!

CodePudding user response:

Not ah, directly with the system administrator password.
Small programs don't need to log in, simply run,

I give myself

CodePudding user response:

You compiled program is still unable to control access?
Change the database table name, and then to update PB source code, modify the access table name
Isn't it can't access to the original program!

CodePudding user response:

This is the problem? Source code update casually, can ah

CodePudding user response:

I don't know if there is any ORACLE database, process management, in the SQL SERVER 2005, you can directly see the connection, and then to end it, ha ha,,

CodePudding user response:

If you have any update previous small program, after upgrading to abolish it,
Either delete you one by one hand.

CodePudding user response:

Delete the original client does not directly!

CodePudding user response:

Use the view? Modify the view.

CodePudding user response:

Each other is compiled programs to run, now an independent client, although the source program in my hand, and they can also be used,
No update, because do not need to upgrade, if want to increase function, to do a directly, cover up too fast, didn't consider so complicated, is only 300 k thing ah,
To delete it one by one, is not so real, I always can't black face one by one to check their computer,

Well, I can think of is to modify the view structure, let the other side of the data error window, just like this way, your side also use the view of a small program to modify the,
I want to have a way to work a little bit small, ha ha, I this is boxed in,