12 replies to this topic

[terryjohnson16]

This is what has to be done:

Quote

Explain the statements below. All your explanations should be understood be the business user not the techie. Your answer must cover every aspect of the statement. (Who, What, Where, When, How).

1) CREATE PROFILE EDITORS
LIMIT PASSWORD_LIFE_TIME 60
IDLE_TIME 45 CONNECT_TIME 480;


2) ALTER PROFILE TEMPCONSULT
LIMIT IDLE_TIME 30;

4) CREATE ROLE MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.CUSTOMER TO MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.CUSTOMER_ADDRESS TO MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.WANT_AD TO MAKEINDEX;

[wxtracker93]

I'm not very familiar with database coding, sorry.

[GameOfLove]

I know SQL. Is the question asking what those commands mean?

[terryjohnson16]

GameOfLove, on Apr 21 2008, 09:49 PM, said:

I know SQL. Is the question asking what those commands mean?

Yeah.

[Stormchaser]

Here's a few sites on how to translate the commands:

http://www.w3schools...l/sql_intro.asp

http://www.1keydata.com/sql/sql.html

http://ugweb.cs.ualb...ual/chapt6.html

[terryjohnson16]

Stormchaser, on Apr 21 2008, 10:32 PM, said:

Here's a few sites on how to translate the commands:

http://www.w3schools...l/sql_intro.asp

http://www.1keydata.com/sql/sql.html

http://ugweb.cs.ualb...ual/chapt6.html

Thanks.

[GameOfLove]

1) CREATE PROFILE EDITORS
LIMIT PASSWORD_LIFE_TIME 60

The number of days the same password can be used for authentication

IDLE_TIME 45 CONNECT_TIME 480;

The allowed idle time before the connection is dropped.

2) ALTER PROFILE TEMPCONSULT
LIMIT IDLE_TIME 30;

The allowed idle time before the connection is dropped.


4) CREATE ROLE MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.CUSTOMER TO MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.CUSTOMER_ADDRESS TO MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.WANT_AD TO MAKEINDEX;

Creating a role in makeindex.

Grating permission to classmate on customer table.
Grating permission to classmate on customer address table
Grating permission to classmate on want ad table.

[terryjohnson16]

GameOfLove, on Apr 22 2008, 01:15 AM, said:

1) CREATE PROFILE EDITORS
LIMIT PASSWORD_LIFE_TIME 60

The number of days the same password can be used for authentication

IDLE_TIME 45 CONNECT_TIME 480;

The allowed idle time before the connection is dropped.

2) ALTER PROFILE TEMPCONSULT
LIMIT IDLE_TIME 30;

The allowed idle time before the connection is dropped.


4) CREATE ROLE MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.CUSTOMER TO MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.CUSTOMER_ADDRESS TO MAKEINDEX;
GRANT INDEX, SELECT ON CLASSMATE.WANT_AD TO MAKEINDEX;

Creating a role in makeindex.

Grating permission to classmate on customer table.
Grating permission to classmate on customer address table
Grating permission to classmate on want ad table.

Thanks..

[terryjohnson16]

3) SELECT CREATED, USERNAME, ACCOUNT_STATUS
FROM DBA_USERS
WHERE INSTR(ACCOUNT_STATUS,'EXPIRED') > 0
OR INSTR(ACCOUNT_STATUS,'LOCKED') > 0
ORDER BY CREATED DESC;

Is this correct for what I got out of this question:
This means that you are going to select the “created”, “username”, and “account_status” columns from the “DBA_USERS” table, and either look for where the “INSTR(ACCOUNT_STATUS,'EXPIRED') > 0 or “INSTR(ACCOUNT_STATUS,'LOCKED') > 0 fields are greater than 0. After finding that the query will put them in order by the desc for when they were created.

[GameOfLove]

terryjohnson16, on Apr 29 2008, 10:46 AM, said:

3) SELECT CREATED, USERNAME, ACCOUNT_STATUS
FROM DBA_USERS
WHERE INSTR(ACCOUNT_STATUS,'EXPIRED') > 0
OR INSTR(ACCOUNT_STATUS,'LOCKED') > 0
ORDER BY CREATED DESC;

Is this correct for what I got out of this question:
This means that you are going to select the “created”, “username”, and “account_status” columns from the “DBA_USERS” table, and either look for where the “INSTR(ACCOUNT_STATUS,'EXPIRED') > 0 or “INSTR(ACCOUNT_STATUS,'LOCKED') > 0 fields are greater than 0. After finding that the query will put them in order by the desc for when they were created.

That seems correct.

[terryjohnson16]

GameOfLove, on Apr 29 2008, 02:54 PM, said:

That seems correct.

Thanks.

[terryjohnson16]

GameOfLove, on Apr 29 2008, 02:54 PM, said:

That seems correct.

Thanks. With your help and my finishing up the rest of my work, I got a 98.

[GameOfLove]

terryjohnson16, on May 5 2008, 09:54 PM, said:

Thanks. With your help and my finishing up the rest of my work, I got a 98.

Congrats!