meta user
network profile
| bio | website | ddbcinc.com |
|---|---|---|
| location | Rochester Hills, MI | |
| age | 36 | |
| visits | member for | 2 years, 4 months |
| seen | 2 mins ago | |
| stats | profile views | 363 |
Oracle ACE
|
Apr 5 |
answered | double date conversion when adding partition |
|
Apr 2 |
answered | Oracle equiv of T-SQL UNION ALL query |
|
Mar 21 |
revised |
Giving permission for each table within a database added 51 characters in body |
|
Mar 21 |
answered | Giving permission for each table within a database |
|
Mar 20 |
comment |
import .dmp file created in OS W2K to Win 2003 Exactly what version of the export utility was used to generate the export file? "Oracle 8" could refer to anything from 8.0.3 to 8.1.7. Exactly what version of the import utility will be used? Since no version of "Oracle 8" was certified on Windows 2003, should we assume that you are able to successfully install Oracle 8 on Windows 2003 and that everything works in that unsupported and untested configuration? |
|
Mar 13 |
comment |
Cannot login to Oracle11g with System username Are you talking about shutting down Oracle via Enterprise Manager (the web-based GUI)? Or via a command-line? Enterprise Manager will request operating system credentials (on Windows, a Windows username & password that is in the ORA_DBA group) in order to start and stop certain services. A command-line tool will not (since, after all, you're using your operating system privileges inherently in that environment). |
|
Mar 12 |
comment |
how to create and insert into a table in an anonymous block @JHFB - You may want to take a look at the thread I just added a link to before writing that new question. |
|
Mar 12 |
revised |
how to create and insert into a table in an anonymous block added 376 characters in body |
|
Mar 12 |
answered | how to create and insert into a table in an anonymous block |
|
Mar 12 |
comment |
Blocking incoming database links @Phil - Maybe I'm missing something. I believe the problem is to prevent database links from a database that you don't control. I don't see how that can be restricted via privileges. Of course, you can certainly prevent people from creating database links in your database that point to other databases. But that doesn't sound like the problem here. |
|
Mar 11 |
comment |
Blocking incoming database links @bonsvr - Added a link to another DBA thread with an example of a logon trigger that attempts to deny access. |
|
Mar 11 |
revised |
Blocking incoming database links added 81 characters in body |
|
Mar 11 |
answered | Blocking incoming database links |
|
Mar 5 |
answered | Oracle Case when problem |
|
Mar 5 |
comment |
ORA-00990 error while trying to grant priviliges: Why is that? @SuhailGupta - OK. So you created a user but then didn't log in as that user. You're still logged in as whatever user you used initially to create the suhail user. Based on the output of your query, I'm assuming that you logged in as SYS initially and are still logged in as SYS. |
|
Mar 5 |
comment |
ORA-00990 error while trying to grant priviliges: Why is that? @SuhailGupta - Did you log in as suhail? Did you grant suhail the SYSDBA role? |
|
Mar 5 |
comment |
ORA-00990 error while trying to grant priviliges: Why is that? @SuhailGupta - If you own the table, you automatically have access to the data. If you do not own the table, the owner of the table would need to grant you INSERT privileges on the table in order to insert data and SELECT privileges on the table in order to select the data. |
|
Mar 5 |
answered | ORA-00990 error while trying to grant priviliges: Why is that? |
|
Feb 27 |
reviewed | Reject suggested edit on A database trigger is an alternative for? |
|
Feb 27 |
answered | A database trigger is an alternative for? |
