TypeScript classes
TypeScript
extends JavaScript classes to include type parameters, implements clauses,
accessibility modifiers, member variable declarations, and parameter property
declarations in constructors.
In following
example created class employee with filed “fullname” and constructor which Constructs
full name and assigned to class property.
TypeScript class
code example:
class Employee {
fullname: string;
constructor(public firstName: string, public
middleInitial: string, public lastName: string) {
this.fullname = firstName + "
" + middleInitial + " " + lastName;
}
}
var user = new Employee("Shourya", "Nagnath", "Kendre");
window.onload = () => {
var elFullNameName =
document.getElementById('lblFullNameName');
elFullNameName.innerHTML = user.fullname;
};
HTML code:
<html lang="en">
<head>
<meta charset="utf-8" />
<title>TypeScript HTML App</title>
<link rel="stylesheet" href="app.css" type="text/css" />
<script src="ClassesExample.js"></script>
</head>
<body>
<h3>Classes example</h3>
<label id="lblFullNameName"></label>
</body>
</html>
Result page:

This is my 2nd
article on SQL server 2016, in this article I will explain in detail how to maintain
user permissions or security.
SQL Server Security Management
A. Developers Access Control
It is very
crucial to manage each user’s access rights as it can become hectic when need
to manage 10-20 users with multiple permissions on their windows
authentication.
To manage
permissions among users, SQL has provided access management using windows
groups.
Below are
the steps to create any local windows group
1. Search “Computer
Management” and open it.
2. Expand
“Local Users and Groups” and then open Groups.
3. Add new
local windows user group and map windows users under it. Eg. “SQLUserGP_Read”,
“SQLUserGP_Write” and “SQLUserGP_DBA”

Windows group can be added in same fashion like windows user.
It is always advisable to provide execute rights to all
developers so execute below query for same.
GRANT EXECUTE TO [VSPC0129\SQLUserGP_Read]
GRANT EXECUTE TO [VSPC0129\SQLUserGP_Write]
B. SQL/Web User Access Control
To restrict
hackers from manipulate our database, we should always provide minimal access
to users.
It can be
done at object level and database level.
Object Level
Advisable to provide access to only
required objects so that other objects can’t be accessed in case of any hacking
attempts.
Database Level
Keep all the interactions through
stored procedure and user should only be allowed to execute SPs (will not have
even select rights).
धन्यवाद मित्रो !!
Thanks Friends