Friday, August 21, 2015

DATABASE USER ROLES (SQL SERVER)

Each user in a database can be in one or more roles
 
db_owner
can perform all configuration and maintenance activities on the database, and can also drop the database.

db_securityadmin can modify role membership and manage permissions. Adding principals to this role could enable unintended privilege escalation.

db_accessadmin 
can add or remove access to the database for Windows logins, Windows groups, and SQL Server logins.

db_backupoperator
can back up the database.

db_ddladmin
can run any Data Definition Language (DDL) command in a database.

db_datawriter
can add, delete, or change data in all user tables.

db_datareader
can read all data from all user tables.

db_denydatawriter
cannot add, modify, or delete any data in the user tables within a database.

db_denydatareader
cannot read any data in the user tables within a database.

Wednesday, August 12, 2015

AppSMART Celebrates World Youth Day in Colombo

ICT, Media and Tech Youth from 38 communities, celebrated World Youth Day On August 8 at Dialog HQ auditorium. AppSMART the 1000 Youth Mobile Technology Training program initiated by Shilpa Sayura Foundation, Dialog Idea Mart, YES Film School and Sri Lanka ICT Student Society (SLIS)

ICT & Tech Youth from celebrated World Youth Day On August 8 at Dialog HQ auditorium 1000 Youth Mobile Technology...

Posted by YES Media on Sunday, August 9, 2015

Monday, August 10, 2015

New Treands in ICT : Wearable Technology

Smart Phones will play a major part in next generation Mobile Teachnology. The  wearable technology, such as smart watches, and other accessories, is the next big thing. Currently Wearable technology  is $4- to $5 billion market and could grow $30- to $50 billion. Wearable technology mainly be used on Medical, Sports, Engineering and Education applications. Wearable technology uses computer and advanced electronic technologies uses software, sensors and connectivity to enable objects to exchange data with a manufacturer, operator and/or other connected devices, without requiring human intervention. Wearable technology is related to ubiquitous computing. As an example a patient condition can be monitored by doctor remotely.