Follow me !
Search this blog
-
Recent posts
Tags
- AIX
- Apple
- automation
- backup
- best practices
- Bootcamp
- cloud
- cursor
- db2
- db2 compression
- db2 hadr
- db2 performance
- db2 tuning
- db2 v9.5
- db2 v9.7
- db2move
- db2pd
- indexes
- install
- iPad
- iPhone
- linux
- Macbook
- memory
- NULLID
- Oracle
- package
- performance
- restore
- runstats
- script
- shell script
- sql
- SQL805N
- SQL Server
- stored procedure
- tablespace
- time machine
- tuning
- ubuntu
- ubuntu 9.04
- upgrade
- Windows on Mac
- wordpress
Disclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
Tag Archives: T-SQL
Stored Proc for SQL Server and DB2 UDB
We often grant permissions against table for users. Some use the GUI, some just script it out. I wrote a quick stored procedure that will take couple of input parameter and run the grant against the tables. Just for the … Continue reading
Posted in database, db2, sql server
Tagged db2, dynamic sql, execute, grant, loop, sp_executeSQL, SQL Server, SQL/PL, stored procedure, T-SQL
Leave a comment