0
What else can I help you with?
Difference between user and schema oracle?
Well, darling, in Oracle, a user is an account used to log in and access the database, while a schema is a collection of database objects (tables, views, etc.) associated with a particular user. So, think of a user as the key to the front door, and a schema as the fancy furniture and decor inside the house. You can have multiple schemas in a single user account, just like you can have multiple rooms in a house. Easy peasy lemon squeezy!
What privilege should a user is given to log on to the oracle server?
The CREATE SESSION system privilege by legrand charles(B.E CSE)
Why you must create a unique user account?
for a security reason
To modify smo information view affiliated users and create or modify jcavs user accounts a jcavs user must be logged in as a?
To modify smo information view affiliated users and create or modify jcavs user accounts a jcavs user must be logged in as a?
Which Oracle type must you use to make values inserted into an associative array persist over the life of a user's session?
Package variable
How do you undo a GRANT in Oracle?
Use the Oracle revoke command Example: revoke execute on procedure from user;
How do you create a new profile on a computer?
If you mean user then: You must have administrator rights. For windows: Start Menu >> Control Panel >> Users >> Create new User For Mac: Apple Icon >> System Preferences >> Users >> Create new User
How do you find user privileges in oracle?
sql>select * from user_tab_privs;
When should you create a role in Oracle?
I think role is for these two purposes. 1>to grant a group of related privileges to a user 2>to simplify the process of granting and revoking privileges
Is Oracle or SAP better?
Type your answer here... Oracle is a user friendly software on the other hand SAP is not easy to use . SAP can be useful for big and vast organization, and oracle is best for small organizations .
When a user creates an object without a tablespace clause where will oracle store the segment?
It will go in the default tablespace of the user that creates the object.
How do you accept user inputed values in oracle in loop?
Variables beginning with a single ampersand "&".
