The average user AAA
Select * from dba_role_privs
WNBB NO YES
CONNECT the NO YES

Select * from dba_sys_privs
CREATE ANY VIEW NO

Select * from role_sys_privs WHERE ROLE='WNBB'
The CREATE SESSION NO
EXECUTE ANY PROCEDURE no

Why AAA or can give authorized grant other users' own table? I don't want to let the AAA table herself to grant other users, is there a way to? Or do you want to default oracle select their tables can be authorized to others?

I am a DBA

CodePudding user response:

AAA user is the owner of the object, can free distribution, like your own things, who is willing to give to whom,
Can create a trigger control

CodePudding user response:

Oracle is the default select their tables can be authorized to others? This statement is wrong,
Only you manually grant, other users will have to select the permissions, except sys or other DBA user ~

CodePudding user response:

The building Lord have such concerns or from the access control enough fine or trouble, do A little sore, should be for the application to access A user, if other applications or someone want to direct the background database, so only by other users to log in, should not be direct application to connect A user,

If really can't make any compromise, then trigger may be the only way out for you,

CodePudding user response:

The original poster can also be granted to users with lower permissions, let it can only make simple query, connection can be, also can give him a higher authority, but add a trigger, once the user permissions granted to other users, the trigger is triggered; Can be determined to one thousand users to share with others, you're not can't

CodePudding user response:

Only you as a manager to authorize mo 'n' yukio okamoto, a 'g' hugrant select, update, insert, delete on buser. Tabaaa to usera;