Develop new user and new role for assistant dba

Assignment Help Database Management System

Reference no: EM1372837

You need to create a new user named ASSOCDBA1 and a new ROLE named JRDBA1 that can be used for an assistant DBA. You want the new role to contain the DBA role that the SYSTEM user has with ADMIN OPTION (when it pertains to the current SYSTEM user setting). You also want the new role to be password-protected with a password of MJOAG2T. Once the role is created, assign the role to the new user ASSOCDBA1, but do not make it the default role.

Execute your script to create the new user, the new ROLE, assign privileges to the role, and assignment of the ROLE to the user.

Reference no: EM1372837

Questions Cloud

Strong property rights constrain economic growth : Strong property rights constrain economic growth by strictly regulating economic behavior. Proponents of economic growth entitlement that growth leads to greater equality of income in an economy

Show the lifecycle nutrition presentation : How are the needs at this stage in life different than the other stages and how important is nutrition at this stage in preventing future disease?

Diagram the equilibrium : A worker faces a review every year. He prefers to spend time making if he will be reviewed; otherwise he would prefer to use time somewhere else.

Progressive insurance inspected insurance from the customers : Progressive Insurance inspected insurance from the customers' viewpoint and saw how difficult it was to get an auto claim processed and paid by insurance companies

Develop new user and new role for assistant dba : You need to develop new user named ASSOCDBA1 and new ROLE named JRDBA1 which can be used for assistant DBA. You wish the new role to contain DBA role that the SYSTEM user ha

What is the force acting on the other support : A person who weighs 620 N stands at x = 5m, right on the end of a long horizontal diving board that weighs 350 N. The diving board is held up by two supports, one at its left end at x = 0, and one at the point x = 2.00 m.

How to draw the reflected ray : Find out the critical angle for the glass-synthetic interface (same as for the glass-diamond interface). Sketch a picture of the incoming ray as it interacts will all subsequent interfaces.

Associated press stated that initial probes by the nhtsa : the Associated Press stated that initial probes by the NHTSA revealed that brakes were not applied in 35 of the 58 cases studied.

Nash equilibrium based question : Consider the following data for a simultaneous move ggiven: If you advertise and your rival advertises, you will each earn 5 million dollar in profits.

User Account

All Pages