Compiled Messages: ------------------------------------------------------------ Message no. 498 Posted by Naziya Shaik (snaziya) on Monday, October 2, 2006 11:22pm Subject: small doubt in proj 6 its simple but i wanted to be sure!!!! granting permission on all tables on dbsec...means can we use grant xxxx any table to yyyy; Naz ------------------------------------------------------------ Message no. 499[Branch from no. 498] Posted by Ravinder Gaur (rgaur) on Tuesday, October 3, 2006 1:22am Subject: Re: small doubt in proj 6 Naz, Either you grant on individual tables (using GRANT SELECT ON DBSEC.TAB TO TEST) or do a global grant across the database (GRANT SELECT ANY TABLE to TEST). The later grants select on all tables (dictionary access is not covered here). To grant access to only DBSEC owned tables, you'd have to run individual grants on each table. Typically this is handled thru roles (which I assume will come later on in the course). Hope this helps. - Ravi ------------------------------------------------------------ Message no. 500[Branch from no. 499] Posted by Naziya Shaik (snaziya) on Tuesday, October 3, 2006 1:39am Subject: Re: small doubt in proj 6 Wow manually granting on each and every table is really tiresome method. what if the user xx had some 1000 tables in his database and wants to grant user yy to access xx.tables....then? yes, grant xxxxxx any table to yyyyy makes the particular role or user gives access to the whole database. what does user xx do if he wants to grant 1000 table permission to yy? ya in this proj 6, its simple (around 17 tables); but wht about real time situation? Naz ------------------------------------------------------------ Message no. 501[Branch from no. 498] Posted by Lakshmikar Padmaraju (lpadmaraju) on Tuesday, October 3, 2006 11:01am Subject: Re: small doubt in proj 6 Nazia, I granted privilages to roles using grant xxxx any table to yyyy; and assigned roles to users. Raju ------------------------------------------------------------ Message no. 503 Posted by Ravinder Gaur (rgaur) on Wednesday, October 4, 2006 4:33am Subject: Project 6 I see that DBSEC_CLERK lacks CREATE SESSION privs (#5). I had to grant that additional priv. Anyone else noticed that? ------------------------------------------------------------ Message no. 504[Branch from no. 503] Posted by Naziya Shaik (snaziya) on Wednesday, October 4, 2006 7:19am Subject: Re: Project 6 Yes Ravi, we had to do that extra step.(granting create session to dbsec_clerk user). and then i connected to this user. Naz ------------------------------------------------------------ Message no. 505[Branch from no. 503] Posted by Lakshmikar Padmaraju (lpadmaraju) on Wednesday, October 4, 2006 10:28am Subject: Re: Project 6 Ravi, Yes I did notice that, and I always granting session privilage when ever I create New user for this class projects. Raju. ------------------------------------------------------------ Message no. 506[Branch from no. 499] Posted by Krishnamurth Ashwini (kashwini) on Wednesday, October 4, 2006 12:26pm Subject: Re: small doubt in proj 6 I agree with Ravi. I think there is on more way to do this. What if we give the user DBSec GRANT privileges permission. Then there is not no need to give privileges on every individual tables that user DBsec owns. You can simply login as DBSec user and grant required privileges on ALL TABLES to roles. Ash ------------------------------------------------------------ Message no. 509[Branch from no. 500] Posted by Paras Pradhan (ppradhan) on Wednesday, October 4, 2006 6:14pm Subject: Re: small doubt in proj 6 Can't we use like: grant select in dbsec.* to username? Paras. ------------------------------------------------------------ Message no. 510[Branch from no. 509] Posted by Krishnamurth Ashwini (kashwini) on Wednesday, October 4, 2006 7:11pm Subject: Re: small doubt in proj 6 Paras, Did this command work for you? I'm asking this because, I tried it and it actually gave an error for me. Ash ------------------------------------------------------------ Message no. 511[Branch from no. 506] Posted by Naziya Shaik (snaziya) on Wednesday, October 4, 2006 7:56pm Subject: Re: small doubt in proj 6 did any one of you tried this option..like giving grant privilege to dbsec and then granting some property on all tables to role/user like Ash said. I actually granted on each and every table manually for each and every role/user....which is really tiresome. granting on any table---will allow the user/role to access any thing in tht database. so its not for particular user tables...or schema.. what say? Naz ------------------------------------------------------------ Message no. 517[Branch from no. 510] Posted by Paras Pradhan (ppradhan) on Wednesday, October 4, 2006 11:06pm Subject: Re: small doubt in proj 6 No not tried yet. will try to check. Paras. ------------------------------------------------------------ Message no. 518[Branch from no. 503] Posted by Venkat Munagala (vrmunagala) on Wednesday, October 4, 2006 11:32pm Subject: Re: Project 6 Yes Ravi we need to give the privilege of create session to DBSEC_CLERK user. We hv to do the extra step. ------------------------------------------------------------ Message no. 520[Branch from no. 501] Posted by Rhonda Nichols (renichols2) on Thursday, October 5, 2006 1:59pm Subject: Re: small doubt in proj 6 this is what i did as well. -Rhonda ------------------------------------------------------------ Message no. 521[Branch from no. 510] Posted by Paras Pradhan (ppradhan) on Thursday, October 5, 2006 2:43pm Subject: Re: small doubt in proj 6 Ash: Not working. had to use grant select any table..... Paras. ------------------------------------------------------------ Message no. 522 Posted by Rhonda Nichols (renichols2) on Thursday, October 5, 2006 2:54pm Subject: ACCOUNT USED In project 6, Dr. Liu says he plans on logging in as SCOTT/TIGER before executing our script (SEE TIPS #3 of assignment). Of course, this user does not have permission to create users, profiles, etc. Did everyone just log in as system before creating any objects? -Rhonda ------------------------------------------------------------ Message no. 523[Branch from no. 522] Posted by Naziya Shaik (snaziya) on Thursday, October 5, 2006 3:07pm Subject: Re: ACCOUNT USED Rhonda,we too have to login as scott, and in the script write first statement as connect system...so tht we have privilege to create objects... Naz ------------------------------------------------------------ Message no. 524[Branch from no. 506] Posted by Naziya Shaik (snaziya) on Thursday, October 5, 2006 3:09pm Subject: Re: small doubt in proj 6 Ash, Did you try this option?? "give the user DBSec GRANT privileges permission. Then there is not no need to give privileges on every individual tables that user DBsec owns. You can simply login as DBSec user and grant required privileges on ALL TABLES to roles." Naz ------------------------------------------------------------ Message no. 525[Branch from no. 523] Posted by Rhonda Nichols (renichols2) on Thursday, October 5, 2006 3:11pm Subject: Re: ACCOUNT USED that's what I meant. In order to test our script, we first have to log in as SCOTT but the first statement in our script HAS to be to connect as system because SCOTT cannot create any objects. Just wanted to make sure I was reading it right...Thanks! -Rhonda ------------------------------------------------------------ Message no. 526[Branch from no. 524] Posted by Krishnamurth Ashwini (kashwini) on Thursday, October 5, 2006 3:19pm Subject: Re: small doubt in proj 6 Naz, No, I did not give DBSec any Grant permission, though I was very much tempted to do that:-). I just gave permissions to each and every table just like you did. I am really curious to know if there is any method where you can give access to all tables of a user in a much simpler way, rather than giving permissions to every single table that a user owns. It is really an elaborate procedure that we are following now. I hope someone finds the easier method and posts it here. Ash ------------------------------------------------------------ Message no. 527[Branch from no. 525] Posted by Naziya Shaik (snaziya) on Thursday, October 5, 2006 5:45pm Subject: Re: ACCOUNT USED Yes, not scott but system ------------------------------------------------------------ Message no. 528[Branch from no. 501] Posted by Naziya Shaik (snaziya) on Thursday, October 5, 2006 5:48pm Subject: Re: small doubt in proj 6 Thanks everyone, I hope we will find better and easier way to do this. Thanks Naz ------------------------------------------------------------ Message no. 529 Posted by Anjana Divakar (adivakar) on Thursday, October 5, 2006 9:46pm Subject: resource allocation doubt I have a doubt regarding resource allocation.In the task given, for DBSEC_DEV_PROF the CPU_PER_CALL=1min whereas for DBSEC_CLERK_PROF the CPU_PER_CALL=5 seconds. As per the syntax given in text book, we have to convert to one hundreths of a second. So do we have to convert it to that format? In the text book, it says cpu time allowed per call is 10 secs. So the syntax was CPU_PER_CALL 1000. ------------------------------------------------------------ Message no. 530[Branch from no. 529] Posted by Naziya Shaik (snaziya) on Thursday, October 5, 2006 10:16pm Subject: Re: resource allocation doubt Yes anjana, we have to change to it that format(hundreth of second). Naz ------------------------------------------------------------ Message no. 532[Branch from no. 530] Posted by Anjana Divakar (adivakar) on Thursday, October 5, 2006 11:00pm Subject: Re: resource allocation doubt thanks naziya! ------------------------------------------------------------ Message no. 534[Branch from no. 498] Posted by Sagun Piya (srpiya2) on Friday, October 6, 2006 12:21am Subject: Re: small doubt in proj 6 yes you can use that statment grant xxxx any table to yyyy; Sagun ------------------------------------------------------------ Message no. 535[Branch from no. 529] Posted by Sagun Piya (srpiya2) on Friday, October 6, 2006 12:24am Subject: Re: resource allocation doubt yes Anjana, we have to multiply the second by 100. Sagun ------------------------------------------------------------ Message no. 538[Branch from no. 529] Posted by Gnaneshwar Bukka (gbukka) on Friday, October 6, 2006 1:00am Subject: Re: resource allocation doubt Hi Anjana, That was a good question, I refered the text book but was still not sure. You got it cleared. Good job. Thanks to all. Gnaneshwar Bukka ------------------------------------------------------------ Message no. 540 Posted by Rhonda Nichols (renichols2) on Friday, October 6, 2006 9:35am Subject: Error SQL> connect scott/tiger; Connected. SQL> connect system; Enter password: Connected. SQL> connect scott/tiger; Connected. SQL> @project6.sql Enter password: ERROR: ORA-01031: insufficient privileges and the first line in my project6.sql file is CONNECT SYSTEM; Any idea why I can connect at command prompt but not from within my script. YES-I am typing it correct. -Rhonda ------------------------------------------------------------ Message no. 542[Branch from no. 540] Posted by Rhonda Nichols (renichols2) on Friday, October 6, 2006 10:29am Subject: Re: Error Cancel that thought....works now....must have been user error. ------------------------------------------------------------ Message no. 546[Branch from no. 540] Posted by Sagun Piya (srpiya2) on Friday, October 6, 2006 9:13pm Subject: Re: Error Hi Rhonda, you have to give the password that you have first created while installing oracle. I think to connect with the system, we have to give that password. Sagun ------------------------------------------------------------ Message no. 550 Posted by Daniel Thurston (dsthurston) on Saturday, October 7, 2006 10:23am Subject: Question: db_blocks?? howdy? on the project 6 homework we need to create a profile DBSEC_CLERK_PROF with LOGICAL_READS_PER_CALL=10KB The definition in the book for creating a profile lists: LOGICAL_READS_PER_CALL db_blocks I assume that the question wants 10 kilobytes if so how big is a db_block (or where do I find it out on my system). Or are you interpreting the question to ask for 10k db_blocks?? thanks DanT ------------------------------------------------------------ Message no. 554[Branch from no. 520] Posted by Eric Knuth (elknuth2) on Saturday, October 7, 2006 12:43pm Subject: Re: small doubt in proj 6 I used the same thing as well, but I was tempted to script it to read all tables belonging to XXXX then grant premissions to them. Eric ------------------------------------------------------------ Message no. 555[Branch from no. 504] Posted by Eric Knuth (elknuth2) on Saturday, October 7, 2006 12:43pm Subject: Re: Project 6 I had actually done this at the point of user creation just to test the account. Eric ------------------------------------------------------------ Message no. 556[Branch from no. 550] Posted by Eric Knuth (elknuth2) on Saturday, October 7, 2006 12:47pm Subject: Re: Question: db_blocks?? Aren't the default for those default defined in the spfile? Eric ------------------------------------------------------------ Message no. 557[Branch from no. 550] Posted by Kelsey Pooley (kjpooley) on Saturday, October 7, 2006 1:28pm Subject: Re: Question: db_blocks?? I was wondering the same thing...good question. Kelsey ------------------------------------------------------------ Message no. 558[Branch from no. 550] Posted by Naziya Shaik (snaziya) on Saturday, October 7, 2006 6:25pm Subject: Re: Question: db_blocks?? Dan logical_reads_per_block implies maximum number of blocks that can be read per call.... so i think 10KB implies 10000 blocks so we should specify it as logical_reads_per_block 10000 wht say? Naz ------------------------------------------------------------ Message no. 562[Branch from no. 530] Posted by Suresh Methuku (smethuku) on Saturday, October 7, 2006 8:15pm Subject: Re: resource allocation doubt Thanks a lot guys for your suggestion suresh. ------------------------------------------------------------ Message no. 563[Branch from no. 550] Posted by Suresh Methuku (smethuku) on Saturday, October 7, 2006 8:31pm Subject: Re: Question: db_blocks?? I am having the same doubt. Guys please react soon. suresh ------------------------------------------------------------ Message no. 566[Branch from no. 556] Posted by Daniel Thurston (dsthurston) on Saturday, October 7, 2006 11:00pm Subject: Re: Question: db_blocks?? yes on my machine it was spfiletech.ora db_block_size=8192 you could do a search for spfil*.ora to locate it on your machine. But . . . the answer makes no sense. Something tells me that the question is wrong. DanT ------------------------------------------------------------