sqlcmd usefull command

To open sqlexpress

sqlcmd -S .\SQLEXPRESS

To show all databases

EXP sp_databases
go
Advertisements

Create user and Grant access in Oracle

Create a new user in oracle:

http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_8003.htm#i2065278

Grant in oracle:

http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_9013.htm#i2155015

Drop an user in Oracle

http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_9008.htm