{{theTime}}

Search This Blog

Total Pageviews

How to grant permissions?

GRANT CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM, CREATE TRIGGER, CREATE TABLE, CREATE PROCEDURE, CREATE SEQUENCE TO user_name

GRANT CREATE SESSION TO user_name

No comments:

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...