in linux the administrator account is called top

That is, nobody logs in with these accounts instead, applications use these accounts to connect to the database, and users log in to the applications.

In addition, you may want to create user accounts that are used by applications only. You can create user accounts for database administration, and grant only a subset of administrative privileges to those accounts. For example, a database application developer needs privileges to create and modify tables, indexes, views, and stored procedures, but does not need (and should not be granted) privileges to drop (delete) tablespaces or recover the database. Oracle recommends that you grant each user just enough privileges to perform his job, and no more. If the user will be creating database objects, then give the user account a space usage quota on each tablespace in which the objects will be created. Grant the appropriate system privileges, object privileges, and roles to the account. When you create a user account, you must not only assign a user name, a password, and default tablespaces for the account, but you must also do the following:

A user account is identified by a user name and defines the attributes of the user, including the following:ĭefault tablespaces for permanent and temporary data storage For users to access your database, you must create user accounts and grant appropriate database access privileges to those accounts.

In linux the administrator account is called top