Oracle References and Code Samples
Monday, July 11, 2005, 10:09 AM - Oracle
I ran across the following site for oracle samples, and a good list of reference materials.
Oracle References and Code Samples
Enjoy!
[ add comment ] | [ 0 trackbacks ] | permalink |
( 3.1 / 274 )SQLPlus Client Installation
Tuesday, May 17, 2005, 07:23 AM - Oracle
It's been a while since I made some SQL+ scripts work, especially on a new box, and it took me a little doing. Basically, you have to install the oracle client, and don't forget to set the ORACLE_HOME environment variable to something like "C:\progra~1\Oracle\product\10.1.0\Client_1". Then, you need to do the InstantClient install of the client tools and sqlplus. Extract both of these to a directory, like "C:\progra~1\Oracle\product\10.1.0\Client_1\sqlplus", add this to the PATH environment variable, and VIOLA. SqlPlus can log in and see your TNSNames.ora file in "C:\progra~1\Oracle\product\10.1.0\Client_1\network\ADMIN".
I love it when a plan comes together.
[ add comment ] | [ 0 trackbacks ] | permalink |
( 3 / 243 )Granting "TRUNCATE"
Monday, May 9, 2005, 07:09 AM - Oracle
"TRUNCATE" table is not a permission in oracle. It is not a DML command, like "SELECT", but a DDL command, like "CREATE". As such, to grant "TRUNCATE" on a table, you really need to grant "DROP ANY TABLE" and the user will have "TRUNCATE" ability.[ add comment ] | [ 0 trackbacks ] | permalink |
( 3.1 / 244 )Oracle Permissions
Monday, May 9, 2005, 07:07 AM - Oracle
I haven't worked in Oracle for a while, and it's amazing to me how quickly my skills slip!!
So, here are a few basic queries to "get the job done"
To check the assigned permission of a user, use:
SELECT * FROM user_tab_privs WHERE grantee = 'PROSET_ETL' AND PRIVILEGE = 'DELETE'
[ add comment ] | [ 0 trackbacks ] | permalink |
( 3 / 231 )
