Experience Sharing, SQL Databases

[SQL] Grant User Permissions

The task which I was doing today required me to prepare a SQL script which grants the user to execute the user defined functions and stored procedures. While SQL Server Management Studio allows us to set the permission by a few clicks, it is good to prepare them using the script so we can re-use them in case we have run them in the development and production databases.

A simple script to grant user with execute permission for stored procedures. It applies to all stored procedures in the selected database.

/* GRANT EXECUTE TO THE ROLE */
GRANT EXECUTE TO <user>

Next, I found out that my application needs to set permission for the user defined functions. I felt I could have spent the same amount of time to search the script to automate the process and manually wrote the script one by one. The script below can help,

/* GRANT EXECUTE TO THE USER DEFINED FUNCTIONS */
SELECT 'GRANT EXECUTE ON [' + SCHEMA_NAME(schema_id) + '].[' + [name] + '] TO MyRole;'
FROM sys.objects
WHERE type IN ('TF','FN');

There is another script which could help,

declare @name varchar(100), @qry varchar(2000)
declare cursor cursor_temp
for select name from dbo.sysobjects where OBJECTPROPERTY (id, IsProcedure) = 1
open cursor_temp
fetch next from cursor_temp into @name
while @@fetch_status = 0
begin
set @qry = ' grant execute on [dbo].[' + @name + ' ] to [ <user_name> ]'
exec (@qry)
fetch next from cursor_temp into @name
end
close cursor_temp
deallocate cursor_temp

I hope this could help.

Advertisements
Buffet, Japanese Food, Lunch & Afternoon Tea, Non-Halal Food, Singapore - Bugis, Singaporean Food

Rocku Yakiniku

Rocku Yakiniku, 201 Victoria Street, #04-06 Bugis+, Singapore 188067.

I saw the Eatigo’s promotion for the Japanese charcoal grilled buffet with 50% discount for weekday’s lunch. The promotion did not include drink. The promotion ended in 30th June. I found it quite good for my team gathering and suggested it to my boss to bring the team for a quarterly gathering. Unfortunately, the booking through the Eatigo cannot be done because of limited quota allocated per day. Although, we cannot make it for team lunch, my colleague and myself went on our own on one of the weekdays.

Upon arrival, we saw a big crowd of people in the restaurant, we wondered whether they were closed for event or something. I approached the waitress and told her about my booking. We were served shortly after that.

Unlimited meat replenishment, from beef, pork to chicken but need to pay extra for salmon and prawns. I do not recommended to go for salmon as it could be hard to grill on this kind of surface. The salmon might be quite sticky on the surface and it would be wasted. 

Our first round of meat consisted of pork, beef and bacon. We did not order the chicken 🙂 The fire is hot and easy to grill and then, we started to add more meat and placed more orders for meat and mussels. The meat did not really marinated but it is still nice tasted. However, I found the bacon was slightly salty. I think it is common. There are sauces at the bar for us to dip with the meat. Besides that, we grilled some mushrooms and vegetables which we can get them from the bar too. Selection of vegetable is quite limited.

Somehow, after the first round of mussels, the next order for more mussels came late and we got 3 plates in the end. So it became mussels feast for the 2nd last grilling session before we wrapped up our lunch with last round of grilling the beef and pork.

Other sides dishes from the bar which I took was the chawanmushi, fried noodle and edamame.

Overall, it is quite worthy to try for the charcoal grill which limited to 80 minutes per session and I think they do not really check the timing during our visit, but they will ask us to pay the bill before end of the session. Without the promotion, this buffet is quite expensive with limited selection and quite poor services because of big crowd especially when the tour groups are in the restaurant.

Dinner & Supper, Halal Food, Singapore - Tampines, Singaporean Food, Western Food

Simple Wrapps

Simple Wrapps, 2 Tampines Central 5 #B1-11 Singapore 529509.

With the points from the 365 Health App, I converted the points into vouchers of Simple Wrapps which I can get a salad or a wrap of Chef selection. I ordered the Journey to Norway from the menu. Based on the website, the ingredients for the salad are romaine lettuce and Mesclun leaves, smoked salmon, beetroot, capsicum, cherry tomatoes and broccoli. The vegetable is fresh and I did not put any dressings. It is an healthy choice for a day.

Lunch & Afternoon Tea, Singapore - Lavender, Singaporean Food, Thai Food

Soi 47

Soi 47, 111 King George’s Ave, Singapore 208559.

The Soi 47, which is located at King George’s Ave nearby the Lavender MRT station, is the second branch after the successful one at Lorong 6, Toa Payoh. I was introduced to this Thai restaurant by a food blogger who shared the news about the restaurant’s second branch at King George’s Ave last month.

It opens barely for less than a month, it has a lot of patrons to this restaurant which located closely to the office buildings and HDB neighbourhood. My colleagues and I decided to try out this restaurant a day before the Raya holiday. It was pretty new and less crowded back then 🙂

One of their signature fish dishes on their menu, the steamed Seabass with Thai lime sauce. It is worth for a try as the sauce is really good and tasty. The fish was well cooked when it was served and slowly heated up by the fire to keeping the fish hot. It does make the sauce slight tastier after that but do not take too long to finish it else the fish will overcook.

I could stop having the fish and the sauce that my colleagues could not finish it ^_^

For the first time, we tried the crispy fried chicken with sweet lime sauce. The thick sauce over the crispy fried chicken maintained it juiciness inside. However, the portion is a bit small for four persons. However, if you order with some other dishes, it is just nice as you can try different dishes in small portion.

The clear Tom Yam with seafood which consists of fried fish, prawns, mussels and cuttlefish cooked with lemongrass and small chilies padi. In my opinion it is better than Beer Thai at Golden Mile Complex. We let the soup kept boiling and it is kicking, however, it is not salty. 

Usually we will order the fried kangkung with sambal, the basic one which we can get it anywhere, they do have fried kangkung with garlic. The fragrance of fried garlic made it worthy to go without sambal. You may want to balance your taste with something neutral after having the tom yam soup and the lime sauce.

For dessert, we ordered the sticky mango and a bowl of cold red ruby. Both are favourite and famous Thai desserts. It is using sliced jackfruit and water chestnut coated with red colouring tapioca flour, boiled in the hot water, combined with coconut milk, sugar syrup and ice.

Last but no least, iced Thai milk tea can go with or without. It is not too sweet style as the usual local Thai milk tea does.

Experience Sharing

Day 179

Yesterday’s night, I spent my evening with my friend walking from Kallang to Geylang for hearty dessert before we continued our walk all the way to Kembangan MRT before going home. Throughout the whole journey, we talked a lot of things, from work to life and relationship. She shared her stories, her sisters’ stories and her friends’ stories to convinced me, sometimes I should just create my own opportunity instead of waiting it to happen one day or just pray hard to the God everyday, hope things will just turn up in front of us.

Today’s little baby step surprised me with an immediate reply which seemed to reading my mind. I shared the conversation with my friend. My friend did not come surprised by the answer. Now, I have to spend a bit time to search where the venue to be. I shall praise the Lord for His blessing. I believed the prayer I made this morning was listened by Him and He provided what I wanted when, I was wondering how I could do it when it seemed not a right time.

Italian Food, Lunch & Afternoon Tea, Singapore - Bendemeer, Singapore - Lavender, Singaporean Food, Western Food

Deliveroo

Address: 114 Lavender St #01-15 CT Hub 2 Singapore, 338729.

I would like to share my Deliveroo’s dine-in experience with food from Aloha Poke and Dapaolo. It is located at CT Hub 2, Lavender, Singapore. You can probably spot it during the lunch time where a lot of pick ups happened during that time and you can see some crowds. Other than that, it is located at level 1 of the empty rows of shoplots.

You can check out their Click & Collect’s menu from the mobile application. Here is my reviews for the following 2 restaurants I tried recently.
Aloha Poke

It is specialized in Poke bowl, serving healthy raw fish, salad and superfood. I ordered the Lil’ Swell from their menu. The size of the bowl seems to be medium with 1 single scoop of Mentai Salmon with the based of the salads, mixed white rice and brown rice. You can choose 2 sides such as fish roe, cherry tomatoes and many more. Then, a single selection of superfood such as avocado and quail egg. There is an option to choose with or without salad dressing too.

It is quite big bowl of salad when it served, so mix it well before eating it, sometimes it can be a little messy. Overall, it is healthy, delicious and no complaint.

Dapaolo

It serves Italian food such as freshly made pizza and pasta. We ordered the Meat Lover Pizza, which consists of salami and baked ham with bolognese sauce and mozzarella on a thin crust. When it was served hot, it was cheesy and yummy.

During one of our visits, they treated us with free ice-creams from Ben & Jerry’s.

This branch has some of the kitchens located within the same shop, therefore, there is no delivery charges, you can have it immediately after it is served and you can collect points from every purchases using your Ez-link card. Although the price is quite expensive, once a while treat yourself with good food is important too.

Chinese Food, Home-cooked Recipes

Dragon Boat Festival

The Dragon Boat Festival, also known as duan wu jie in Chinese, is a traditional holiday that commemorates the life and death of the famous Chinese scholar Qu Yuan (Chu Yuan). Okay, so who was this guy and what he did? I did a little more research on this special occasion.

Apparently, this Chinese scholar, who committed suicide by jumping into the river after tying himself with big rock on the 5th day of the 5th lunar month, was one of the advisors of Chu Kingdom. Jealousy was the main reason, people did not like him, talked bad about him and king did not take his advice in the end. It was pretty much like our current lives as well. These people are just everywhere at anytime.

And, so how does it related with the dragon boat? I just did a little bit more searching and found out many fishermen tried to rescue him, but the body is never found. Fishermen worried about fish would eat his body, they threw food into the river to feed the fish and they tried to scare fish away by splashing the water with their paddles and beating the drums on the long narrow boats. Well, that is the drums, boats and paddling, where does there dragon come from?

Well, Chinese always believe there is water-dragon under the river or sea. One of villagers poured the rice wine into the river and the drunken water-dragon appeared floating on the river. Woah!

To celebrate this date which Chinese people make “zong zi”, the glutinous rice wrapped with bamboo leaves. The ingredients used to make the glutinous rice dumplings are varied from egg, beans, dates, fruits, sweet potato, walnuts, mushrooms, meat to full plain or vegetarian.

Being away from home and it has been years my aunt stopped making the glutinous rice dumplings. With my CEO’s mother handmade and the hot Chinese tea, make my dinner perfect for both visual and taste bud satisfaction.