0
What else can I help you with?
How do you create a user in oracle 10g?
To create a user in Oracle 10g, you can use the SQL command CREATE USER. For example, you can execute CREATE USER username IDENTIFIED BY password; to create a new user with a specified username and password. After creating the user, you typically need to grant privileges using the GRANT command, such as GRANT CONNECT, RESOURCE TO username;, to allow the user to log in and perform actions in the database.
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
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
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?
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.
