Compiled Messages: ------------------------------------------------------------ Message no. 252 Posted by Peter Ping Liu (TEC5363PL) on Sunday, September 10, 2006 9:11am Subject: Reminder Starting from this week, our projects will involve coding with SQL. I want to encourage everyone to conitunue sharing our knowledge and skills and help each other resolve problems along the way. However, I do want to remind everyone that please do not "share" your entire project or attach your whole file. It is perfect to share ideas including code segments, but not your entire file or project. ------------------------------------------------------------ Message no. 264[Branch from no. 252] Posted by Sagun Piya (srpiya2) on Monday, September 11, 2006 5:43pm Subject: Re: Reminder I love the idea that Dr. Liu stated. We can help each other in coding problem and everything else Sagun ------------------------------------------------------------ Message no. 270[Branch from no. 264] Posted by Ravinder Gaur (rgaur) on Tuesday, September 12, 2006 7:32am Subject: Re: Reminder I'm sure that coding will be easy for everyone given everyone's interest and knowledge in Oracle. Moreover Oracle's online documentation coupled with some great sites are of awesome help. I'm listing a few that I use quite often -- http://metalink.oracle.com http://asktom.oracle.com http://otn.oracle.com http://www.ixora.com.au (mainly performance tuning) http://www.dba-oracle.com http://www.oracle-faq.com - Ravi ------------------------------------------------------------ Message no. 271[Branch from no. 270] Posted by Daniel Thurston (dsthurston) on Tuesday, September 12, 2006 10:15am Subject: Re: Reminder Thanks for the links. DanT ------------------------------------------------------------ Message no. 273[Branch from no. 270] Posted by Gnaneshwar Bukka (gbukka) on Tuesday, September 12, 2006 11:08am Subject: Re: Reminder Hi, I agree with Sagun and Ravi, with the material available on are class website, also in most of the other internet sites and with mutual interaction, am sure we can have fun and knowledge. Thank you for the links ravi. Have fun. Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 278[Branch from no. 270] Posted by Venkat Munagala (vrmunagala) on Wednesday, September 13, 2006 2:20pm Subject: Re: Reminder Thanks for links Ravi. The class resources given also help us in doing some good coding. Inspite of these I found the the book "Oracle 10g, The Complete Reference" to be good. Simple things were described clearly in the book. Rohit ------------------------------------------------------------ Message no. 279 Posted by Rhonda Nichols (renichols2) on Wednesday, September 13, 2006 2:46pm Subject: Free Publications Here is a link where you can get free publications inlcuding ORACLE magazine which is (I think) good reading. http://alps.tradepub.com/free/orm/ enjoy! -Rhonda ------------------------------------------------------------ Message no. 282[Branch from no. 252] Posted by Kelsey Pooley (kjpooley) on Thursday, September 14, 2006 11:26pm Subject: Re: Reminder I really like this text book. It gives clear examples and explanations. The previous textbooks I have used for Oracle were difficult to use. The examples were very complex and included a lot of code that was not always necessary for the example given. I think it is much easier to take it one step at a time and see how the code builds than to throw it all in together! Kelsey ------------------------------------------------------------ Message no. 285 Posted by Daniel Thurston (dsthurston) on Thursday, September 14, 2006 11:51pm Subject: Question Slow week so I thought I'd post a question. Ok with oracle using global authentication the book mentions LDAP as one of the central user management systems that you can login to. My question is, what are the others?? I assume that Active Directory would be counted as LDAP, but what about kerberos, NIS, NIS+ etc??? I could see where NIS would add more security issues; "ypcat -k passwd" will list users and their encryped passwords for one to run a cracker on. Just curious DanT ------------------------------------------------------------ Message no. 286[Branch from no. 285] Posted by Ravinder Gaur (rgaur) on Friday, September 15, 2006 6:22am Subject: Re: Question Dan, We also used Oracle Names that was available until 9i. LDAP is the way to go for Oracle name resolution starting 10g. - Ravi ------------------------------------------------------------ Message no. 287 Posted by Kelsey Pooley (kjpooley) on Friday, September 15, 2006 7:15am Subject: Listing the User Information For this part of Project 3: “At the end of the creation, list the user information that shows a successful creation of the above user account. (15 points)” “A database dictionary view "dba_users" can be used to find user information. There are, of course, other ways to do it, which are acceptable as well.” I tried doing a select * from dba_users where username = ‘whichever name I chose’; Is this the best way to do this? I didn’t see where it showed the 20MB quota when I did it this way. Would it be better to select the specific fields that Dr. Liu told us we needed to have or is there a better way altogether? Kelsey ------------------------------------------------------------ Message no. 288[Branch from no. 287] Posted by Lakshmikar Padmaraju (lpadmaraju) on Friday, September 15, 2006 9:08am Subject: Re: Listing the User Information Kelsey, If use Select * ----- it shows all information, dr. LIU asked show user accounts created successfully, so you can select username, password, account_status, default_tablespace, temporary_tablespace, and profile from dba_users table where User name in ('DBSEC','VPD_CLERK1'). Thats what I did. Also use command SET TERMOUT ON , this will make sure that output displayed on the screen, in case It turned off. Hope this helps you. Raju. ------------------------------------------------------------ Message no. 289[Branch from no. 286] Posted by Lakshmikar Padmaraju (lpadmaraju) on Friday, September 15, 2006 9:11am Subject: Re: Question Ravi, We also started using LDAP for our 10g. Raju. ------------------------------------------------------------ Message no. 290[Branch from no. 288] Posted by Krishnamurth Ashwini (kashwini) on Friday, September 15, 2006 9:45am Subject: Re: Listing the User Information Kelsey, Raju is right..This is how I too did. Ash ------------------------------------------------------------ Message no. 291[Branch from no. 290] Posted by Kelsey Pooley (kjpooley) on Friday, September 15, 2006 10:16am Subject: Re: Listing the User Information Thank you! Kelsey ------------------------------------------------------------ Message no. 293[Branch from no. 291] Posted by Gnaneshwar Bukka (gbukka) on Friday, September 15, 2006 12:46pm Subject: Re: Listing the User Information Hi, I had the same question and was about to post it. Anyway, thanks alot guys. Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 298[Branch from no. 279] Posted by Paras Pradhan (ppradhan) on Friday, September 15, 2006 3:51pm Subject: Re: Free Publications I used to get a free oracle magazine before from otn. is this the same one.. i think this is the different one. Paras. ------------------------------------------------------------ Message no. 299[Branch from no. 285] Posted by Paras Pradhan (ppradhan) on Friday, September 15, 2006 4:02pm Subject: Re: Question I guess nis and nis+ runs only in the unix/linux environment and has less featues as compared to LDAP. May be there are patches to patch oracle nis for the compatibilty. If yes that is really really nice since nis is really nice open authentication system . ------------------------------------------------------------ Message no. 300[Branch from no. 288] Posted by Suresh Methuku (smethuku) on Friday, September 15, 2006 5:30pm Subject: Re: Listing the User Information Thanks a lot raju.It helped me a lot. Suresh ------------------------------------------------------------ Message no. 306[Branch from no. 287] Posted by Sagun Piya (srpiya2) on Friday, September 15, 2006 10:02pm Subject: Re: Listing the User Information yes you can use dba_users. sagun ------------------------------------------------------------ Message no. 311 Posted by Eric Knuth (elknuth2) on Saturday, September 16, 2006 1:54pm Subject: Very helpful SQL tool SQL Developer This product is free from Oracle. I wouldn't develope any SQL code without it. http://www.oracle.com/technology/products/database/sql_developer/index.html Eric ------------------------------------------------------------ Message no. 312[Branch from no. 285] Posted by Eric Knuth (elknuth2) on Saturday, September 16, 2006 2:00pm Subject: Re: Question LDAP is an authentication system built around a database. It in itself is a protocol, but so much more. LDAP as a protocol (like NIS etc) provides the "language" that client programs can talk to servers. LDAP also provides lookup data for for address books, etc. LDAP, however, really hits its stride with its ability to provide permissions and schema for all of its users. Hope I helped. Eric ------------------------------------------------------------ Message no. 315[Branch from no. 306] Posted by Naziya Shaik (snaziya) on Saturday, September 16, 2006 6:18pm Subject: Re: Listing the User Information Thank you Raju. ------------------------------------------------------------ Message no. 316[Branch from no. 282] Posted by Naziya Shaik (snaziya) on Saturday, September 16, 2006 6:18pm Subject: Re: Reminder Thank you for the links, They were so helpful... Naz ------------------------------------------------------------ Message no. 317[Branch from no. 311] Posted by Naziya Shaik (snaziya) on Saturday, September 16, 2006 6:20pm Subject: Re: Very helpful SQL tool Nice Link, we can even get news and updates too thts cool Thanks Eric Naz ------------------------------------------------------------ Message no. 319[Branch from no. 315] Posted by Venkat Munagala (vrmunagala) on Saturday, September 16, 2006 8:04pm Subject: Re: Listing the User Information Thank you Raju, By doing the way u said, it clearly displayed the required things instead of displaying all instead of using select * from dba_users. ------------------------------------------------------------ Message no. 324[Branch from no. 319] Posted by Anjana Divakar (adivakar) on Saturday, September 16, 2006 10:37pm Subject: Re: Listing the User Information Thanks Raju for your help. It was really useful while coding. ------------------------------------------------------------ Message no. 327[Branch from no. 298] Posted by Rhonda Nichols (renichols2) on Saturday, September 16, 2006 11:13pm Subject: Re: Free Publications I believe it is the same. -Rhonda ------------------------------------------------------------