Compiled Messages: ------------------------------------------------------------ Message no. 943 Posted by Naziya Shaik (snaziya) on Monday, December 4, 2006 4:43pm Subject: Important point in Project 9 I know this is kinda late to post something related to project 9 But I wanted to make a point regarding project 9 When professor mentioned to track all the activities such as select, update,insert,delete statements on the table CUSTOMER all the statements were being audited in the first execution...but when it is executed again then the update statement is not being audited. My question is "why is the update statement not being audited in case of failure(failure means 0 rows updated) " you must have observed that delete statement is being audited even in case of failure (means 0 rows deleted) As professor couldnt see the update statement being audited- he reduced points for few students. So contact professor if you think you lost points even though it is being audited. Note: Make sure you include table creation and data insertion statements in the script when ever you submit the script file. Thanks Naz ------------------------------------------------------------ Message no. 948 Posted by Paras Pradhan (ppradhan) on Wednesday, December 6, 2006 6:30pm Subject: Doubt on final project hi all In the final project question do we just do what the question say? For example: Last question says: --------- Audit the activities on CUSTOMER table. (15 points) You will design and implement the following auditing functions on the CUSTOMER table. * Track all "SELECT" activities on the CUSTOMER table, including database user, operating system user, and time when the operation is performed. * Track the changes when CREDIT_LIMIT is set to a value above $5,000. * Track the CUSTOMER table when a customer record was deleted. --------------------- do we just enable the audit function or after enbaling the audit functions we need to show by creating tables after auding and show the contents of dba_audit_trail; Thanks Paras. ------------------------------------------------------------ Message no. 949[Branch from no. 948] Posted by Paras Pradhan (ppradhan) on Wednesday, December 6, 2006 6:34pm Subject: Re: Doubt on final project Plz ignore my previous post... Here it is again. ----------------------- hi all In the final project question do we just do what the question say? For example: Last question says: --------- Audit the user activities of two users. You will set up an audit mechanism to monitor all activities by two (2) database users: VPD_CLERK1, VPD_CLERK2. (10 points) --------------------- do we just enable the audit function or after enbaling the audit functions we need to show by creating tables and show the contents of dba_audit_trail; Thanks Paras. ------------------------------------------------------------ Message no. 950[Branch from no. 949] Posted by Ravinder Gaur (rgaur) on Wednesday, December 6, 2006 7:04pm Subject: Re: Doubt on final project I would not include anything that the question doesn't ask for. However, to ensure that the auditing works as expected, I'd definitely experiment as you suggest. - Ravi ------------------------------------------------------------ Message no. 951[Branch from no. 950] Posted by Paras Pradhan (ppradhan) on Wednesday, December 6, 2006 11:12pm Subject: Re: Doubt on final project Ravi, Yeah i thought so we don;t need to include. Thanks paras. ------------------------------------------------------------ Message no. 955[Branch from no. 951] Posted by Rhonda Nichols (renichols2) on Thursday, December 7, 2006 7:18am Subject: Re: Doubt on final project This is the same question I asked last week...glad someone else is having doubt. It just seemed too simple but I just did what the question asked and tested it thouroughly. -Rhonda ------------------------------------------------------------ Message no. 956[Branch from no. 955] Posted by Lakshmikar Padmaraju (lpadmaraju) on Thursday, December 7, 2006 10:49am Subject: Re: Doubt on final project I talked Dr. Liu about final project when he published the specs in early November, He said basically it is summary of the all projects we did (except name and value changes some places), he also said that he did not include specs in detail as did in individual projects. Step 7 should be Project 9 and step 8 should be project 10. I just copied project 9 for step 7 (modified credit limit from 25000 to 5000) and copied project 10 for step 8 (replaced DBSEC_CLERK user with VPD_CLERK2). Also in step 6 to create policy function DBSEC user should have CREATE PROCEDURE privilege or DBA Privilege (project 8 we did this, but final project specs did not mention it). Dr. Liu said Granting DBA privilege to DBSEC is security issue, but He said he will accept it because we did project 8 same way) I didn't give DBA privileges to DBSEC instead I gave Create procedure privilege. I granted the following privileges to DBSEC Create session, create table, create view, and create procedure. I hope I am not confusing. Raju. ------------------------------------------------------------ Message no. 959[Branch from no. 956] Posted by Krishnamurth Ashwini (kashwini) on Thursday, December 7, 2006 6:48pm Subject: Re: Doubt on final project Yes..the final project is an amalgam of all the other projects we've done. All we have to do is make some minor changes to our previous scripts and put it all together. Thank you all for your help and support. This was a great class and I learned a lot from everyone of you. Thanks again, Ash ------------------------------------------------------------ Message no. 964[Branch from no. 948] Posted by Sagun Piya (srpiya2) on Friday, December 8, 2006 7:52pm Subject: Re: Doubt on final project hey paras, I think we don't have to include for our final project. But to verify whether audit function is working or not, we can check it when we are doing a final project. Sagun ------------------------------------------------------------ Message no. 970[Branch from no. 959] Posted by Gnaneshwar Bukka (gbukka) on Saturday, December 9, 2006 12:55pm Subject: Re: Doubt on final project Thanks to everyone, I did the same way, assemble all the previous projects and make minor changes. Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 975[Branch from no. 964] Posted by Venkat Munagala (vrmunagala) on Saturday, December 9, 2006 7:17pm Subject: Re: Doubt on final project Thanks a lot guys for sharing valuable information. This class really helped me to learn a lot. Rohit ------------------------------------------------------------ Message no. 976[Branch from no. 975] Posted by Suresh Methuku (smethuku) on Saturday, December 9, 2006 7:19pm Subject: Re: Doubt on final project This class was really helpful and I really enjoyed this class. The information posted was very useful and it made me learn a lot. Thanks to all guys. Suresh ------------------------------------------------------------ Message no. 982[Branch from no. 959] Posted by Kelsey Pooley (kjpooley) on Saturday, December 9, 2006 9:13pm Subject: Re: Doubt on final project I agree. I too learned a lot from this class. Everyone was willing to help out if someone had problems with a project or a concept. Thanks to everyone for their contributions. Kelsey ------------------------------------------------------------ Message no. 984[Branch from no. 982] Posted by Daniel Thurston (dsthurston) on Saturday, December 9, 2006 10:33pm Subject: Re: Doubt on final project Thanks all; I've learned a great deal from you! Cheers DanT ------------------------------------------------------------ Message no. 988[Branch from no. 975] Posted by Anjana Divakar (adivakar) on Sunday, December 10, 2006 10:36am Subject: Re: Doubt on final project Thank you class! I learnt a lot this semester from all of you. All the extra information and tips was extremely useful. thanks, anjana ------------------------------------------------------------ Message no. 992[Branch from no. 984] Posted by Eric Knuth (elknuth2) on Sunday, December 10, 2006 1:59pm Subject: Re: Doubt on final project I have learned alot of things that I have already started implementing in my job. Eric ------------------------------------------------------------