TABLESPACE AND USER RIGHTS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

TABLESPACE AND USER RIGHTS

Author

Topic

sadiquep
Starting Member

1 Post

Posted - 2010-11-03 : 16:46:08

hai friends

i need migrate to mssql from oracle

suppose i have in oracle a tablespcae for a spicefied user

( following query i am using in oracle .. how i can use this in

ms sql)
=============================
simply i need to create tablepscae inv_detailes and aloow it for user
inv001122
how i can do it

anybody please...............

====================================
CREATE TABLESPACE INV_DETAILES
DATAFILE 'INV_DETAILES.dbf' SIZE 20M AUTOEXTEND ON
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TEMPORARY TABLESPACE tmpdata_INV
TEMPFILE 'tmpdata_INV.dbf' SIZE 10M AUTOEXTEND ON;
CREATE USER invv001122 IDENTIFIED BY invvaabbcc;
ALTER USER invv001122 DEFAULT TABLESPACE INV_DETAILES
QUOTA UNLIMITED ON INV_DETAILES;
ALTER USER invv001122 TEMPORARY TABLESPACE tmpdata_inv;

GRANT dba TO invv001122;
GRANT connect TO invv001122;
GRANT CREATE SESSION TO invv001122;
GRANT CREATE TABLE TO invv001122;
GRANT CREATE PROCEDURE TO invv001122;
GRANT CREATE SEQUENCE TO invv001122;
GRANT CREATE TRIGGER TO invv001122;
GRANT CREATE VIEW TO invv001122;
GRANT CREATE SYNONYM TO invv001122;
GRANT ALTER SESSION TO invv001122;
=====================================

edit: moved to proper forum

Swaynebell
Starting Member

8 Posts

Posted - 2010-11-04 : 12:11:06

Hi,

SQL Server doesn't use the tablespace concept that Oracle does. The closest concept is "Filegroups", which you can review in Books Online.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources