Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: maka1
  • Order by date
  1. maka1

    Help with Privileges in new database

    hi mufasa, thanks. you were right, running these two queries returned different results. On my existing database, it returned: SQL> select owner, table_name, privilege from user_tab_privs order by 1,2,3 OWNER TABLE_NAME ------------------------------...
  2. maka1

    Help with Privileges in new database

    hmm... to Robbie: the app i am using to connect will hang for the new database (in the trace, hangs on execution of the query i posted earlier). to Mufasa: I'm not too sure what I have to do here. I ran 'describe user_tab_privs' and see this: Name Null...
  3. maka1

    Help with Privileges in new database

    Hi Mufasa, thank you for that. So indeed, the roles are the same. the queries are the same, I do not understand why the existing database works, but the new one will not. The only difference I guess as mentioned before is the slightly newer version in the new database.. Any ideas? I am...
  4. maka1

    Help with Privileges in new database

    hmm.. okay running what you suggested Mufasa, I get no bind variables have been defined. But in my app, I know the bind variables have been set. Running this: SELECT NULL, OWNER, OBJECT_NAME, CASE WHEN OWNER IN...
  5. maka1

    Help with Privileges in new database

    Hi Robbie, I can probably get this SQL modified, but not immediately and rather get it working with the existing query since it should be working. So how did you test if the query I gave out worked for you? Because when I run this query through SQL Plus, it tells me "SP2-0552: Bind variable...
  6. maka1

    Help with Privileges in new database

    Hi, yes, in fact I have been trying to see the tables that the user (the one who created it in the first place). I ran a trace of what query was being sent, apparently this is the query which I'm having a bit of trouble breaking down. SELECT NULL, OWNER, OBJECT_NAME, CASE WHEN OWNER IN...
  7. maka1

    Help with Privileges in new database

    Hi, thanks for the help. After granting resources to my user, I was able to create tables just fine. But I am still unable to see these tables for some reason. I see that the tables are there from going onto the enterprise manager. so if this user was the one who created this table, having...
  8. maka1

    Help with Privileges in new database

    Hi, I am trying to create a new oracle databsae, but cannot seem to create a user with the correct privileges. I am having trouble creating a user with less than admin privilegs but want them to be able to create any table, select any table, but only within this schema. I was trying to...

Part and Inventory Search

Back
Top