MS SQL SERVER equivalent commands for the following Oracle commands

[Guest_imported]

Hi! I am new to SQL. Can anyone please help me with the MS SQL SERVER versions of these Oracle database commands:

(The underlying OS is Windows NT)

#ls -la $ORACLE_HOME

sql>SELECT username, password FROM DBA_USERS

sql>SELECT * FROM DBA_DB_LINKS


sql>SELECT * FROM DBA_SYS_PRIVS


sql>SELECT table_name, username, tablespace_name from DBA_TABLES

sql>SELECT * FROM DBA_ROLE_PRIVS

sql>SELECT * FROM DBA_TAB_PRIVS


sql>SELECT*FROM DBA_COL_PRIVS

INIT.ORA

 

[culshaja]

Not to sure if I have remembered the Oracle stuff correctlty but these might be the ones:

sp_helprotect - gives infromation on the permissions associated with a role

sp_tables - gives the informtion similar to DBA_TABLES

sp_table_privileges 'table_name' - gives the priviliges on a table

sp_column_priviliges 'table_name' - gives the specified tables column privilige information

sp_linkedservers - gives the name of all the linked servers

sp_helplogins - similar to DBA_USERS


I'm not sure if a lot of the stuff cannot be directly mapped, but the information is available.

James


James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[Guest_imported]

James,
Thank you for the response. That gives me a start. I was reading up on SQL server commands and to know the user names and passwords, it seems that the table syslogins is used. Is this the same as sp_helplogins since this also has dba users information.
And what command would you run for system privileges in sql server?

Thanks,
Ruchi