Skip to Main Content
Forums

Java SE (Java Platform, Standard Edition)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to display "Loading data..." to the user

843805Dec 1 2006 — edited Dec 6 2006
Hi I have a complex ui screen.

In that there is a panel, which displays a graph to the user and it updates to a different graph, depepnding upon the user clicks.
I need to get a lot of data from the backend and then change the graph to the user.

When i am loading hte data, i need to change the panel display to indicate that the data is being acquired and processed.

I dont want to use the cardlayout,
i want to know what other appoaches i can use to show the information to the user.

One of the things i have beein thinking about is dim the current panel and show a message box inside the panel i am updating.

Does anyone know how i can change the alpha(and make it dimmer) in case of a JPanel and throw a small popupwindow inside th epanel to display the message?

any clue or hint is greately appreciated,

thanks,
vani

Comments

SomeoneElse

> GRANT SELECT ON ALL VIEWS OF USER_1 to USER_2.

No such thing.  Grants must be made one at a time.

However, this is fairly easy to do with a script and dynamic sql.

TSharma-0racle

There is no such thing. You can give "SELECT ANY TABLE" privilege to that user but its not good to give this privilige to anyone unless you know what you are doing. But this privilege should be able to gi ve access to views or future views. You can always test this.

Frank Kulash

Hi,

As the others have said, each GRANT only applies to a single object.  Unfortunately, Oracle dosn't have any way to group objects for prinvileges.  User_1 shopuld just include a GRANT statement (or a call to a grant script) in every scriopt that creates a view.

You could write a database trigger to do this automatically, but it's probably not worth the effort.

If a user is continually creating new views (or tables), that could be a symptom of a poor design.  What exactly is uesr_1 doing?  What arre the views for? 

900163

You can run the below a query where you will  get the lost of view names so that you can run them as a script/

DECLARE

   v_sql    VARCHAR2 (4000);

   v_sql1   VARCHAR2 (4000);

   v_SQL2   VARCHAR2 (4000);

BEGIN

   FOR i IN (SELECT table_name

               FROM ALL_VIEWS

              WHERE owner = 'USER1')

   LOOP

      v_sql :=

            ' GRANT DELETE, INSERT, SELECT, UPDATE, DEBUG  ON USER1. '

         || i.table_name

         || 'USER2';

  

      EXECUTE IMMEDIATE v_sql;    

      v_sql := '';

  

   END LOOP;

END;

Kapil

The alternative solution is create a ROLE, grant all access to the role and then grant this role to the schema. As and when a new view is created, grant the access to the role and it will give access to all those schemas who have access to role.

unknown-7404 
Kapil wrote:




The alternative solution is create a ROLE, grant all access to the role and then grant this role to the schema. As and when a new view is created, grant the access to the role and it will give access to all those schemas who have access to role.

Except that won't allow ANY access within named PL/SQL blocks since roles are disabled within such blocks.

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 3 2007
Added on Dec 1 2006
#swing
12 comments
2,003 views