ebakker / aseisql

Automatically exported from code.google.com/p/aseisql
0 stars 1 forks source link

Check if there are permits for "Create Procedure" before running the command "Drop Procedure". #68

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Hi!

Enclose the code in the file Header.sql.

The implementation needs this macro. 
Macro: %USERNAMEDB% --Current User

How do you see?

Original issue reported on code.google.com by zluis0@gmail.com on 9 Nov 2009 at 8:12

Attachments:

GoogleCodeExporter commented 9 years ago
user_id without parameter returns id of the current user.
user_name() without parameter returns name of the current user.
--
I really don't see case when we need the macro...

Original comment by daggett....@gmail.com on 9 Nov 2009 at 8:41

GoogleCodeExporter commented 9 years ago
You are right, the command would user_id().

uid = user_id()--Current user id

Original comment by zluis0@gmail.com on 9 Nov 2009 at 10:12