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

sebkirche / aseisql

Automatically exported from code.google.com/p/aseisql

1 stars 0 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:

header.sql

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

Changed state: Feedback
Added labels: Type-Task

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