General MySQL Oracle SQL Server

<< < … 4 5 6 7 8 9 10 11 12 13 14 … > >>   Sort: Rank

AdventureWorksLT - Downloading and Installing the Sample Database in SQL Server
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to practice you DBA skills with the scaled-down version of the sample database AdventureWorksLT provided by Microsoft, you should follow this tutorial to download and install it first: 1. Go to the SQL S... 2019-08-04, 9312👍, 1💬

💬 2019-08-04 Marc: many thanks

Managing Oracle User Accounts, Schema and Privileges
Where to find answers to frequently asked questions on Managing Oracle User Accounts, Schema and Privileges? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle User Accounts, Schema and Privileges. Clear answers are provided with tuto... 2019-07-30, 1178👍, 0💬

User Account and Schema: One-to-One Relation in Oracle
What Is the Relation of a User Account and a Schema in Oracle? User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) ... 2019-07-30, 1078👍, 0💬

User Role: Group of Privileges in Oracle
What Is a User Role in Oracle? A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users.   ⇒Managing Oracle User Accounts, Schema and Privileges ⇒⇒Oracle Database Tutorials 2019-07-30, 1005👍, 0💬

System Defined User Roles in Oracle
What Are the System Predefined User Roles in Oracle? Oracle 10g XE comes with 3 predefined roles: CONNECT - Enables a user to connect to the database. Grant this role to any user or application that needs database access. RESOURCE - Enables a user to create certain types of schema objects in his own... 2019-07-30, 834👍, 0💬

User Account and Attributes in Oracle
What Is a User Account in Oracle? A user account is identified by a user name and defines user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for query processing work space   ⇒Mana... 2019-07-30, 728👍, 0💬

Use SYS Account to Connect to the Server in Oracle
How To Connect to the Server with User Account: SYS in Oracle? SYS is a very special user account. It has been associated with the highest privilege call SYSDBA. Normally, you should not connect to the server with SYS. But if you want to use it, you need to use a special connect command: &gt;cd ... 2019-07-21, 903👍, 0💬

Built-in Internal User Accounts in Oracle
What Are Internal User Account in Oracle? An internal user account is a system predefined user account. Oracle 10g XE comes with a number of internal accounts: SYSTEM - This is the user account that you log in with to perform all administrative functions other than starting up and shutting down the ... 2019-07-21, 869👍, 0💬

Create a New User Account in Oracle
How To Create a New User Account in Oracle? If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; CREATE USER DEV IDENTIFIED BY dev... 2019-07-21, 866👍, 0💬

Show All User Accounts in Oracle
How To List All User Accounts in Oracle? User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; ... 2019-07-21, 860👍, 0💬

Use Windows User to Connect to the Server in Oracle
How To Use Windows User to Connect to the Server in Oracle? During the installation process, 10g XE will create a special Windows user group called ORA_DBA, and put your Windows user into this group. Any Windows users in this group can be connected to Oracle server with SYSDBA privilege without any ... 2019-07-21, 833👍, 0💬

Revoke CREATE SESSION Privilege in Oracle
How To Revoke CREATE SESSION Privilege from a User in Oracle? If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter SQL&gt; REVOKE CREATE SESSION FROM d... 2019-07-09, 953👍, 0💬

Privilege Needed to Connect to Oracle Server in Oracle
What Privilege Is Needed for a User to Connect to Oracle Server in Oracle? Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter SQL&a... 2019-07-09, 885👍, 0💬

Change User Password in Oracle
How To Change User Password in Oracle? If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; ALTER USER DEV IDENTIFIED BY beginner; U... 2019-07-09, 867👍, 0💬

Grant CREATE SESSION Privilege in Oracle
How To Grant CREATE SESSION Privilege to a User in Oracle? If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the server: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/f... 2019-07-09, 854👍, 0💬

Delete a User Account in Oracle
How To Delete a User Account in Oracle? If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; DROP USER DEV CAS... 2019-07-09, 808👍, 0💬

Privilege to Create Views in Oracle
What Privilege Is Needed for a User to Create Views in Oracle? To be able to create views in a user's own schema, the user needs to have the CREATE VIEW privilege, or the CREATE ANY VIEW privilege, which is more powerful, and allows the user to create views in other user's schema. The following tuto... 2019-06-29, 1008👍, 0💬

Assign a Tablespace to a User in Oracle
How To Assign a Tablespace to a Users in Oracle? When you create a new user, Oracle will assign the SYSTEM tablespace to the user by default. If you want to change this, you can assign a different table space to a user using the ALTER USER command. The following tutorial exercise changes user dev's ... 2019-06-29, 985👍, 0💬

Privilege to Create Tables in Oracle
What Privilege Is Needed for a User to Create Tables in Oracle? To be able to create tables in a user's own schema, the user needs to have the CREATE TABLE privilege, or the CREATE ANY TABLE privilege, which is more powerful, and allows the user to create tables in other user's schema. The following... 2019-06-29, 980👍, 0💬

Privilege to Create Indexes in Oracle
What Privilege Is Needed for a User to Create Indexes in Oracle? For a user to create indexes, he/she needs the same privilege as the creating tables. Just make sure he/she has the CREATE TABLE privilege. The following tutorial exercise gives you a good example on creating view privilege: &gt;.\... 2019-06-29, 928👍, 0💬

Lock and Unlock a User Account in Oracle
How To Lock and Unlock a User Account in Oracle? If you want to lock a user account for a short period of time, and unlock it later, you can use the ALTER USER ... ACCOUNT command. The following sample script shows how to use this command: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyic... 2019-06-29, 862👍, 0💬

Show Privileges of the Current User in Oracle
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are listed in two system views: DBA_SYS_PRIVS, and USER_SYS_PRIVS. You can find out what privileges a user currently has by running a query on those views as shown in the tutorial exercise below: &gt;.\bi... 2019-06-11, 1738👍, 0💬

Managing Oracle Database Tables
Where to find answers to frequently asked questions on Managing Oracle Database Tables? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Database Tables. Clear answers are provided together with tutorial exercises to help beginners ... 2019-06-11, 896👍, 0💬

Privilege to Query Tables in Another Schema in Oracle
What Privilege Is Needed for a User to Query Tables in Another Schema in Oracle? For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to query tables i... 2019-06-11, 871👍, 0💬

<< < … 4 5 6 7 8 9 10 11 12 13 14 … > >>   Sort: Rank

General MySQL Oracle SQL Server