Assume that you are the DBA of the banking organization . One responsibility of DBA is to manage the user access and user profiles. Perform the following tasks by writing the proper SQL statements:

a. Identify and create at least three (3) different roles and provide proper justification for all the three identified roles.

b. Create at least two (2) profiles with different parameters that can be applicable to the bank and justify the requirement of profiles.

c. Create at least six (6) users and assign appropriate profiles from the profiles that as you have created above.

d. Grant the appropriate roles from the three created roles to the users that have been created above.

e. Critically analyze the role of default and temporary tablespaces while creating users.

Note: Your answers should be in MS Word format and you have to provide the screenshots of the commands that you have executed in Oracle or any other database environment in the appendix.

Habilidades: Administração de Bancos de Dados, Desenvolvimento de Banco de Dados

Veja mais: list of databases, what is database system, advantages of database, database examples, database tutorial, database pdf, what is a database management system, types of database, www communes francaises offres d emploi freelance saisie recher cher default htm, seleccione una a free riders b free c free lance d free writters e freeling, sams teach yourself database programming with visual c++ 6 in 21 days, gary d.grant, freelance visual c++ 6.0, visual c++ 6.0 online compiler, https scribie com freelance transcription rc 1 b 1 5 1 2 8 0 eb 5 0 e 8 0 0 1 d 3 8 fa 2 cd 6 bf 5 3 e 0 2 eb 1 2 0 c 8, d model e, ms word xml parser database, ms word macro insert database, free uae companies database ms excel format, functional requirement specification card module inventory database

Acerca do Empregador:
( 18 comentários ) muscat, Oman

ID do Projeto: #15727477

4 freelancers estão ofertando em média $41 para esse trabalho


I am interested in doing this job. I am BS-CS graduate and knows Database programming as well, because of which I can do this task with ease. Have worked on Orcale, MS- Access and MySQL. Relevant Skills and Experience Mais

$80 USD in 3 dias
(12 Comentários)

I can build anything you need!!! I am an expert .PHP Developer and have to my credit many years experience working for employers around the world. My experience includes working as a .PHP Developer Relevant Skills and Mais

$30 USD em 1 dia
(0 Comentários)
$30 USD em 1 dia
(0 Comentários)

sir/ madam I have 4 years of experience in sap Sybase relational database , I read your requirements and will be happy to work on the same , will deliver in time and provide support until your development become sta Mais

$25 USD in 6 dias
(0 Comentários)